In Access 2003, I want to make a query that selects records based on a date.  
I have a form with a combo box labeled: "All Records Since:"  The choices are
Yesterday, One Week Ago, Two Weeks Ago, One Month Ago.  Depending on which is
chosen, I want >Date()-2, >Date()-8, >Date-15, ...

How do i make a simple sum query.
3 tables:
OrderDetails: ID, Bproduct, OrderNo, ordQTY
Invoices: SInvoiceNO, Bproduct, shipmentdate, arrive, vessel

I have an MS-Access lookup table that contains various categories and
subcategories. The fields are:
-------------------------------------------------
tblCategory:

My query either returns 1.5 million records or it wont run due to the
following error.
"The SQL statement could not be executed due to an ambiguous join."
Here is the set up.

There is a way to display empty cells as zero in a report, I just
can't remember how it works ... Can someone remind me how that works?

My Access 2002 database lists everyone in an organization that has different
types of transportation passes.  Wanting to keep a record of all employees
who's ever had a pass (even if they don't have one anymore), I included the
column "MonthCanceled".  I'm trying to generate a ...

I was hoping someone could help a newbie.
I have a table named FSAClients with Feilds such as EthnicGroup, StartMonth,
StartYear,EndMonth,EndYear. Im trying to get my query results to calculate
the sums of both the Total and Percent Columns ( sum of Total column will

I have query with the following criterea in the date field [Forms]![Frm - MMR
Form]![RunDate].
I copied this from another query that works perfectly.  But, I get an error
that says the Jet database does not recognize this feild.  I can't figure

My query has three fields - name,date,notes.  Each name will have several
dates.  I want to select only the latest date for each name, so that I get a
report which gives me the latest notes for each name.  I cannot work it out.  
Any help would be appreciated.

I would like to group like groups in one column while having amts sum for
those groups

I am having a terrible problem creating a running sum in a query. I have
created a [uniquefield] in the query by combining the [Date] and [AutoID]
field. I am trying to calculate a running sum in my [TotOH] and [TotProj]
fields in this query. Can anyone show me what the ...

I have a query that has two tables joined together.  The first table has
fields:
Plant
Material Code

I have an Access 2003 front end to an SQL 2000 database.  On an employee form
with a subform for related records that I include a button to delete the
employee record.  This will run a query to delete the related records and
then another to delete the employee record.  I have a ...

Hi. I'm struggling to get my query to bring back the information I want it to:
Here's the fields with the criteria
Contacts.MemberOption  Contacts.MemberStatusID  Contacts.MemberOption
1 AND 1 AND 1 OR

I have a query as follows:
Day              Product Code
2/1/05             SOS
2/1/05            SBT