Having Problems Setting a Date Range In a Report

[Benjamin Bolduc]

Hi everyone,

I have a report whose query criteria is set to a series of comboboxes on the form that opens it.

I can get the comboboxes to work great together using Iif statements, but the one problem I'm having is with the date.

I have two fields on my form that I would like to be able to enter a Start and End date to create a range in my reports query.

The Iif statement method I'm using for the simpler query does not work for this.

How would you all go about this the most effectively? I've searched through millions of posts in this forum but can't seem to find anything that touched specifically on my problem.

I'll look forward to your responses.

Thank you,
Ben

 

[KenHigg]

So you have a form that has two text boxes, one for the start date and one for the ending date. And you want to use these as the criteria in a report's underlying query?

kh

 

[Benjamin Bolduc]

Yes, that's correct.

I know it seems easy, but I can't get it to work

Can you help me out?

-Ben

 

[KenHigg]

In the query, just put something like the following in the date's criteria:

between #forms!frmMain!txtFromDate# and #forms!frmMain!txtToDate#

Let me know if you can't get it to work.
kh