Adding query run date to a separate table

[Maverick28]

Hi all,



I have built a database which is going to be run daily by my team. Now for auditing purposes I need to populate a table with run dates.

I have built a table with 1 column called Run date and everytime the macro is run, I want a query inside to add that days date into the table.

What`s the best way to do this with queries I can put inside the general macro?

Thanks in advance!

[aytee111]

Create an append query to append the run date to the table and put it as the last step in the macro.

[Maverick28]

Figured out where I was going wrong. I was trying to have Now() as criteria, not as an expression! Facepalm!