Multiple Criteria

[NigeP]

Hi

I would like to create a query that will be converted into a report.
I would like the criteria to ask
Begin Date and End Date?
Is this possible?

Thanks for any help

 

[Topher]

i believe you can, by creating a string variable with the SQL Query statement in it, and appending the date variables to it.

IE

dim strSQL as string
dim begindate as string
dim enddate as string

strSQL = "SELECT table1.* FROM table1 WHERE table1.begindate = "

strSQL = strSQL & begindate & " AND table1.enddate = "

strSQL = strSQL & enddate & " ; "

see what im getting at?? hope that helps

 

[Sybil]

An easier way of doing this without SQL is to just put this in the criteria section under the date field:
Between [Enter Start Date] and [Enter End Date]

When you run the query dialog boxes will appear and ask for the dates.

-Sybil