search query by date

[flic]

For my computing coursework i have to build a stock
control database, but although it is almost finished it is
missing the most important thing, and time is running out
so PLEASE HELP!

I have got a query which orders both the delivery lines
and order lines (both of which have dates) by the month.
My user wishes to select a month from a combo box and to
have the query show only what has gone in and out in that
month. Is this possible with only showing the months with
the information for which are continually changing, also
both the delivery line and order line have dates on.

Can anybody help?

 

[John Vinson]

For my computing coursework i have to build a stock
control database, but although it is almost finished it is
missing the most important thing, and time is running out
so PLEASE HELP!

I have got a query which orders both the delivery lines
and order lines (both of which have dates) by the month.
My user wishes to select a month from a combo box and to
have the query show only what has gone in and out in that
month. Is this possible with only showing the months with
the information for which are continually changing, also
both the delivery line and order line have dates on.

Can anybody help?

If your tables are correctly set up, sure. Just use a combo box to
select the month; the bound column of the combo should be a number 1
(January) to 12 (December), and the criterion on the date field