I have a simple data base that tracks our packs of timber stock at a sawmill.
Each pack is it's own entry line in the database.
The first colum in the data base is called "Status". The packs can either
be, Stock, Sold or Despatched and are changed manually from stock to sold or

I have 1 question regarding the following query.  I need to know why when I
run the query it is prompting me for the date 2 times.  
SELECT qry_AMUWork_Rcd_Date.DateRcd, tblCorrWork.Frequency,
tblCorrWork.RptName, tblCorrWork.MISNumber

Ken Snell
Thank you for Replying me
Question was  I need to do Accumulated sum  in  ToDateQty  Field from
ToDay's Qty field.  

I am self-taught on this silly software - have lots of idiot books and I'm
taking a Intro to VB course and just beginning to understand syntax.
I am trying to do what seems to be a simple DCOUNT and I don't have it
right.  I want to count the times in a specific date range that ...

I had posted this message before and I have code that we cannot get to work
in Access, it will not insert the slots - what is wrong?

How do I get a parameter query to return a list of values. For example I want
to search for a name, how do I get a list of names from the query

I have a very small database of all the coaches in my Region.  At times they
have asked me for reports that just involved a small Query.
The problem is that I would like to show the Regional Director a listing of
all the Query Names.  I do not need the Names, Sizes, Properties, ...

I have a field in a query e.g:  FILEDA:
IIf([dateX]>#22/01/2007#,[dateX]+20,[dateX]+30)
I would then like to place a filter in the criteria section of the design
grid underneath this filed with:

I have been trying to figure this out for the last 14 hours and am
making almost no progress. Any help is GREATLY appreciated.
I have two tables: one is a large table of parliamentarians, dates of
their speeches in parliament, their party and other such info (many

Hi
i am trying to compare USDAMT FROM MY FUNDING TABLE WITH FUNDING AMT FROM MY
ACTIVITY TABLE I TRIED EVERYTHING UNMACHED QUERY, SELECT STATEMENT, <>, IS
NULL but it doesnt show correct info.

My name is April and my attempt in Access is to create a form, also
with a command button which will search for information and put this
information onto a label or box on the form.
SEE EXAMPLE BELOW:

I've search the boards and cannot find an answer to this one.
I have a table set up as follows:
Autonum    Unit #    H Date    Hours   
1    103    1/1/2007    2000   

Here's a problem I have been stuck on for the last three months.
I have a lot of VBA code in an access module that creates queries and
tables.  At the end of the code, I transfer all this information to an
excel spreadsheet using the transfer spreadsheet option.

I have a datafile in the server, and made a "query and design a report" from
my computer for other 3 users, now I need to copy  this query and report
(Instead of recreating the query and report for each 3 user's pc) to other
computer to get the same results what I am getting on ...

Ihave a combo box which has the options 'H', 'no H' and 'All'
I want it to 'filter the base column'
In my query i basically want:
IIf([Forms]![Main]![Combo] = "no H",<>"H","H")