Avoid append queries too many times a day

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I created several append queries to append to add previous day data every
morning. But, how can I build validation to the query so that I or anyone
can't append the queries more than one time a day (which will create double
the data)? Thanks
 
Why do you need to add previous day data every morning? How is your table
structured? Seem like it would be easier to simply include a date field in
your table.

If you don't want to do that, you could probably write some code to update a
field in the originating table so that after the records were exported, the
export date would be filled in. then, when you do subsequent pulls, you
could verify that the export date is blank.
 
By adding a date field (LastDate) with default =Date() it will store
current date along with appended data. Have your macro or event check if
Max(LastDate) <Date() then append.
 
Karl,

Thanks for the suggestion. It make sense to add a date field of when the
macro is ran. But I don't know how to write a macro event to check for
validation. Any help is appreciated.
 
Back
Top