I need help with formatting prompts for dates on a query...

[Manaburrn]

I know somebody can help me - I'm trying to pull data off an AS400 database with Access 97 query. When I put the dates into the criteria line (and it gets automatically formatted with the #'s) like this:

Between #5/1/01# AND #5/1/02#

- it works just fine, but if I ask it to prompt me like this:

Between [Enter the Beginning Date] And [Enter the Ending Date]

- it pulls just the records from 5/1/01 and 5/1/02 (two days worth of records).

I've tried formatting the date ever which way, I've tried formatting the prompt variables like this:

Between ("#" & [Enter the Beginning Date] & "#&quot And ("#" & [Enter the Ending Date]& "#&quot

- that didn't work. Someone please help me! I've spent way too much time on this!

Thanks,

Raphael Bernard

 

[chassle]

I created a form called FrmDateRange. The form has two text boxes, 'fromdate' and 'todate'.

Then in my query criteria i've referenced this form and its text boxes in the following way.

Between [forms]![FrmDateRange].[FromDate] And [forms]![FrmDateRange].[ToDate]

Hope it sorts your date range problem!

 

[Manaburrn]

chassle - thank you very much! That works, and it seems like the ONLY way it's going to work. Oh, and I have to set the format on the text boxes to LONG DATE or mm/dd/yyyy or else I get strange results.

Thanks again!

Raphael Bernard