Update Reports Daily

[Wrecker]

Is there a way to update a report daily,according to the filtered data in a query? I currently have a report based on a query. I only want to report on 1 days data. Each day, I change the filter(date)in the query, but the report dosn't update with the new days data. Then, I have to create a new report everyday to reflect that days data....has to be a better way..

Thanks in advance
Wrecker

 

[jjonesal]

In your query, add the criteria Date() on your date field...

I think that will work. J. Jones
jjones@cybrtyme.com

 

[LonnieJohnson]

In your query that FEEDS the report, put this in the criteria section of the data question.

[What is the date?]

By typing this in the query's criteria section for this date field, you are creating a parameter/prompt. This will ask you for a date when you go to open the report. You will type in 08/29/01 and hit enter. If you do not get the records you desire, it is because they are not in the table.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[LonnieJohnson]

Didn't see JJonesal's reply before I posted. If you only want the current days info, then his way is the best.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[jjonesal]

BTW Lonnie Johnson - that would be HER way... ;-) J. Jones
jjones@cybrtyme.com

 

[LonnieJohnson]

Ooops! ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV