Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there anyway to have a report auto update like the qry does

Status
Not open for further replies.

WrenHerman

Technical User
Jul 6, 2011
1
US
each week new information is inported into out 2007 Access database. I then have to run a report based on this new data. Is there anyway that the reports that have already been created auto update with the new data, or do they need to be created every week? Basically Im wondering if they will update like the qry information does.
 
The reports will reflect that data from your query or table, if the information was updated that is what will show on the report.
 
Not that I disagree with sxschech but to be absolutely clear:
A report will reflect the underlying data (recordsource: table or query) from when it is opened from a closed state.

"Opening" an already open report will not re-run and hence update the data.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top