Latest date

[markedback]

I have a table (Main Table) that needs to be (preferably) updated on a daily basis. The updates result from a Make table query (using two other tables). The make table query creates a temporary table. Then, an append query appends the data from the temporary table into the Main table.

This process sometimes cannot be run on a daily basis and I would like the criteria in the data field of the make table query to look up the latest date in the Main table and use the succeeding date or the date greater than the latest date in the main table as the date condition in the make table query whenever the process is run again.

Please help.

Thanks,
Mark.

 

[genomon]

Can you go to SQL view in the QBE and add a where clause:
WHERE onedate > Max(otherdate).

Ever notice how fast Windows runs? Me neither.