Problem with Printing Parameters on Report

[Santara]

I am using the following formula to print the Start and End Dates on my
report from the parameters on a query.

="Reporting Dates "&[Enter First Day of Reporting Month]&" to "&[Enter Last
Date of Reporting Month]

I have used this successfully on quite a few reports until today.

Two separate reports are giving me the exact same problem.

When I Open the report, the report parameter asks for "First Date...." then
"End Date...." THEN it asks for the "First Date...." parameter again.

Also, I have the formula formatted as Short Date. And that works on the
other reports, but on these two reports, it only shows m/d; i.e. ...6/1 to
6/30 instead of ...6/1/2005 to 6/30/2005.

The query (like the others that work) is using a Between statment in the
criteria row.

When I run the query, it only asks for First and Last dates once.

The problem appears to be in the report, but I can't locate it.

Any suggestions?

Santara

 

[Ken Snell [MVP]]

ACCESS runs the query each time the query is needed for a "sorted/grouped"
record, or for each subreport within a group. I'm betting that your other
reports didn't have a sorting/grouping or subreport setup like the two that
are now giving you this "problem".

I get around this problem by using a form with textboxes to enter the
parameter values, and then have the query get the parameter values from
those textboxes, and I also have calculated fields in the query that read
those values so that I can bind a textbox on the report to each calculated
field and thus use the textbox in other controls' Control Source
expressions.