Reports from an update query

[copleya]

Hi,

I'm trying to create a report based on an update query. I'm fairly new to Access so go easy - small words etc

What I want is a to be able to run a report listing data from all fields with a null value in a field, which then updates this field with today's date - a kind of "export" if you like. I have an update query which updates all of the fields but am unsure how to get a report to list all the records I've just updated.

I can't just set up a seperate query to use that looks for fields with today's date either as this may need to be run several times a day.

Simply put, I want to be able to run a report that will lists fields not already "exported" and then update those records so that they have a date that they were exported.

Thanks
Adam

 

[SimonB1978]

Hi,

I can't think of a way to do that in one step so here is my suggestion:

Select the records which you want to update. Keep them into a temporary table.
Print your report based on this temporary table.
Update the records that figure in your temporary table.

At first, I thought about opening the report and then run the update query, but if a record gets added or modified during that time then it would be updated without figuring on any report.