Minor date problem

[Noreene Patrick]

When I open my report it asks me for Starting Date and Ending Date to pull correct records.

That is exactly what I want, but I also want it to take the Ending Date and put it in an unbound text box to show w/e date for the report.

Is there a way to do this, or is there a simpler way to get this date on the report each time I print (the report is printed each week)

Thanks for your help.

 

[Sohaila Taravati]

Put this on the unbound textbox control sourch:
="From: " & [BeginningDate] & " To " & [EndingDate]
But this has to exactly match the critaria in your query, otherwise it will not work!

 

[Noreene Patrick]

It tells me that Microsoft Jet database engine does not recognize '[beginning date]' as a valid field name or expression.

My report runs off of a crosstab query. I tried to go into the date field of my query and input Between [Beginning date] and [Ending date] but it also said it didnt recognize as a valid field name or expression.

So, do you have anymore suggestions. It worked fine if I used a table as the control source. But, I need the query to pull specific info.

 

[Sohaila Taravati]

You have to make a select query out of your crosstab and put the critaria on that select query, then it will work.

 

[Rich]

You have to either define the parameters for your Start Date End Date as Date/Time or add the date field to the grid again and set the criteria there

 

[Noreene Patrick]

Yes, that worked great!!!

Thanks to you