I'm looking for some advice please.  I have an orders table and a inventory
table - one to many.  When the items in the inventory table are received and
used, I flag a field (closed) yes.  What I would like to do is check the
inventory table per order number and when all items ...

I have a query with the following fields:
dateA,    dateB,       dateC,       dateE,       dateF
1/1/05,             ,    2/1/05,     6/15/05,     12/5/04
        ,    9-15/05,   6/4/04,                 ,     4/15/05

Hi Access Profs,
I create a report which has a stored procedure as control source.
To select the right record for the report, the ID of the active record in
'MY_FORM' is passed to the Input Parameter property.

I have a list of clients all with dates of birth.
I can create a querry that will calculate their exact ages fine but I
want to analysis this in a chart report. The type where age is the X
axis and frequency is the Y access.

Help me!!!! i could not even give a descriptive subject.... :-(
I do not know if one or two queries is enough to solve my problem or if i
need some modification of my database-
Four tables:

Here is an Update statement:
UPDATE Sample, Main
SET Main.State = Sample.State, Main.ST = Sample.ST
WHERE Main.BU=Sample.BU And Main.Desc=Sample.Desc ;

I want to Delete data that is 548 days from Date() on close in a form.  I can
create a query statement <Date-548 but how do I get the delete part?

Hi I use MS ACCESS 2000 and I would like to help me with a Query
I would like to find from all my products all the prices from 400 t
799
How I can do that

Can someone please explain to me how and when to use an IN(Select ... )
statement in the criteria grid of a query? I've seen it used, but I don't
understand it. Why is that better than 2 joined tables?

I created a Crosstab Query that sums amounts by year for a given number of
years.  I want to sum the years for each action that I have listed.  I've
been playing around with it, and can't figure out how to do it because my
year is not an independent field.  Any help would be ...

Is there a way (function) to check the number of fields in a table by a query?
Thanks for any reply,

Is it possible to create foreign keys, indexes, drop & create queries using
SQL with an Access 2000 database?
Thanks,
Ivan

How can I make a multi-parameter query returns all records if none of the
parameters is specified?  What the help suggests works only if the query has
only one parameter. Thanks.

How can we access the SQL text of a saved query and then update it with a
new statement?

Hi! Is it possible to add data to a query - much like an append quary adds it
to a table?
I want to join 3 tables to a query, to make a report where the data in the 3
tables is "sorted together". The reason I don´t want to use append query is