Multiple reports- Able to create macro to update dates

[mdnikki]

Not sure if a macro is what I would use but here is the scenario.



We have a database that we use for distributions for our multiple locations. Each location (140 of them) has a query set up and a report pulls from that query.
On the report currently is a text field that says "Payments received through XXXX". This date varies each time it is run.

So I am trying to figure out how to get this date updated either in each of the queries that pulls the reports or each of the reports without having to go into 140 of them and update.

Hoping this makes sense.

Any help is appreciated.

Nicol

[andy49]

Where is the date stored? In the query for the report? Ignore.

How is the date calculated /worked out. Is it the date the report is printed?


Sent from my iPhone using Tapatalk

[mdnikki]

The date would be entered manually. Originally we had one report that had all 140 locations on it so we would just go into that one report itself and type in the date .

They have now asked us to split it out by location. So we created queries that drive each of the reports but the date would still be a manual entry. Just hoping to manually enter it one time to update the report.

[andy49]

Still a little unclear.

For future reports you could store the current date in a field of the query. Or just use &date() to show the date on the report.

If you need another date in there which is on the database then that's fine.

If the date was entered into a textbox on a report then you could write a code to open the report, strip the date out and store it for future needs.

As I say. Your details are rather vague could you provide a photo maybe of a report you have and what's wrong with it?


Sent from my iPhone using Tapatalk

[mdnikki]

Ok here you go. This is the report the date in the line highlighted in yellow is what is updated each time we run these.

As you can see from the panel we have a report for each Parish and are hoping not to have to manually add this date to each of them. The date is not stored anywhere at this time. It is run quarterly. So each quarter we manually enter the date.

[aytee111]

Create a form, add a text field for the date. The report field (is it a label?) will have a caption of: "Representing..." & Forms!FormName!DateField

You should apply the same logic to the parish and have only ONE query for all. As you say, always having to make changes to all queries is not only time-consuming but leaves you wide open to problems. If you run all the reports together each time you could create a simple VBA module. Any of us could help you with that.