Date filter on switchboard

[Guest]

OK...I give up! I have a report switchboard with two unbound text boxes name
StartDate and EndDate which are to filter the reports by date. In the report
queries in the Date field I have the expression: Between
[Forms]![ReportSwitchboard]![StartDate] And
[Forms]![ReportSwitchboard]![EndDate]. The funny thing is that it works for
one Query/Report, but not the others. I get the message that the expression
is typed incorrectly or is too complex to be evaluated. It seems to me that
if this were truly the case, it would not work at all. Why does it work with
one query and not the rest? Or am I missing something very fundamental here?
Thanks!

 

[Guest]

Well, I really don't know what I did, but somehow I got it all to work. I
tried so many different things, I'm not really sure what the problem was. At
least now I'm good to go!

 

[John Spencer]

A guess - your queries were not recognizing the type of the data in
Forms!ReportSwitchboard!StartDate and Enddate. You can fix that by
declaring the parameters in the query.

Another possibility is that you didn't have the form open when running your
reports. I think this is probably not likely based on your message.

Well, I really don't know what I did, but somehow I got it all to work. I
tried so many different things, I'm not really sure what the problem was.
At
least now I'm good to go!

OK...I give up! I have a report switchboard with two unbound text boxes
name
StartDate and EndDate which are to filter the reports by date. In the
report
queries in the Date field I have the expression: Between
[Forms]![ReportSwitchboard]![StartDate] And
[Forms]![ReportSwitchboard]![EndDate]. The funny thing is that it works
for
one Query/Report, but not the others. I get the message that the
expression
is typed incorrectly or is too complex to be evaluated. It seems to me
that
if this were truly the case, it would not work at all. Why does it work
with
one query and not the rest? Or am I missing something very fundamental
here?
Thanks!