I have a table with the following:
Event    Order Date
1           1      1/1/05
1           2      1/1/05

I have about 50 queries and they all do the same thing except they run off of
different tables.  I have a form that when executed will run all the queries
in succession.  I do not want to always report on all historic data, so I
would like to put a date parameter on the form and ...

I am  trying to write a query or report that will subtract freight charges in
a jobs table from the Invoice fees in the same table. Do I need to have a
field in the table to store the results in that table?
Thanks!

What is the correct way to handle this situation. i have a Order form and a
products sub form. i want to add products to my order but i need the orderID
generated first.  is there a way to have the ability for the user to roll
back the whole order with out generating an order ...

I have feilds Product_ID and TerritoryID in the both tables Table1 and Table2.
Product_ID and TerritoryID is a unique combination.
I'm traying to create a query to get rows from Table1 that don't exist in
the Table2.

I've been trying to get something working, that seems very simple an
yet despite doing a search on this site (and finding good information
can't seem to pull it together.
I hope I am just missing something simple!

I am creating a table using query, but what I need is an autonumber field
that with increment up when a particular feild is blank.  Not all records
that have this field will have a null value.  But I only want the ones that
have a null value to have an autonumber.  Is this ...

Help
I need help on how to insert an "IIF" formula to each field or cell of a
seperate row of 250 rows in an access database table not the query. I could
not use the query for the insertion because all row have different formula.

This query extracts records fine, but produces duplicate values in the
Tencount field.  The Amndt No field contains values from 0 to 171 that track
amendments.  A record can have the same Tencount number but different
Amendment numbers.  I would like the query to not produce ...

Can we merge two pivot table into one by using queries in access datab

how come i randomly get an error message saying table not found (exact error
message is pasted at bottom of this post).  I get this error when trying to
perform a select statment with ADO in visual basic 6 on windows xp to a
remote access 97 .mdb via oledb.

I have a list of minutely gathered data from various dates, I need to find
the max and min for each day and relocate it to a max and min table which
gives the max and the min of the day and the exact time that they occured.  I
have about 50,000 data points, can anyone help?

I have a form that when you select a customer from a combo box, a hidden
textbox called txtCust_Number on the same form is then populated with the
customers number.
On the same form, I have a navigation pane that when I click on an item

Hi, Im trying to show only records that are over 60 days old from thei
creation date. I have a date file called input date and i only want t
see records more than 60 days old. What would the criteria be? I'v
given up on trying myself and hope somebody will be able to come u

Please help
I am trying to create a report that will use a filter query.  when I start
the report, it brings up a form with various boxes for filter criteria.  If a
box is not filled in then all the records are still included.  Once one or