Date-based report

[M0E-lnx]

Again.. need help here.
I have a form that generates a report from a table that contains a list of purchase orders. The fields in the table go like this
[PO Number] | [DATE] | [Vendor] | [JOB]

In my form I have added a textbox and formatted to a short date (1/01/1980).
so what I'm looking for is a way to generate the report b ased on dates equal to or greater than what is in the box.

There is also another box formatted exactly like this one..
The functionality on this one will be reversed.

Ideally, I want to be able to type in 2 dates and see all the records dated between these 2 values. Thanks

 

[gemma-the-husky]

construct a select query based on the table, and base your report on the query

in the query design, take the date column and in the criteria row put

between forms!formname!startdate and forms!formname!enddate

my syntax may be slightly off,but its the basic way to do it