Parameter question

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

I have a query with a parameter in the "criteria" field
asking for a date ex (<=Format([Enter Date],"m/d/yyyy""
23"":""59"":""59"""). I am pulling records less than or
equal to that date. Now, on the report, I would like to
have that date in the header of the report. EX. "Events
through 4/29/04" I would like to use the date I have
entered into the parameter dialog box. How do I capture
the date that I have entered? Thank you very much for
your help!

Susie
 
Susie said:
I have a query with a parameter in the "criteria" field
asking for a date ex (<=Format([Enter Date],"m/d/yyyy""
23"":""59"":""59"""). I am pulling records less than or
equal to that date. Now, on the report, I would like to
have that date in the header of the report. EX. "Events
through 4/29/04" I would like to use the date I have
entered into the parameter dialog box. How do I capture
the date that I have entered? Thank you very much for
your help!
Click to expand...

Add another field to your query, LastDate:[Enter Date]

Your date will then be available to your report as the field [LastDate]

David
 
I have a query with a parameter in the "criteria" field
asking for a date ex (<=Format([Enter Date],"m/d/yyyy""
23"":""59"":""59"""). I am pulling records less than or
equal to that date. Now, on the report, I would like to
have that date in the header of the report. EX. "Events
through 4/29/04" I would like to use the date I have
entered into the parameter dialog box. How do I capture
the date that I have entered? Thank you very much for
your help!

Susie
Click to expand...

Try it this way.
Add an unbound control to the report Header.
Set it's control source to
= "Events through " & [Enter Date]

You might want to reformat your date entry.
If so, try:
= "Events through " & Format([Enter Date],"m/d/yy")

The text within the brackets must be identical to the bracketed text
in the query.
 
Back
Top