How do I copy the LAST RECORD of one table onto another TABLE?

J

JANUS1356

I have a huge table (Table X) created from several tables (tables A, B, C &
D) using a MAKE-TABLE query. I need to update this table from future queries
selecting only those new records from the same source tables and append them
to TABLE X everytime a new set of records are produced by the Make-Table
Query. The purpose of keeping the LAST RECORD from TABLE X is to compare it
with the key in future queries so that those greater than the last highest
key would be the ONLY records to be selected and eventually appended. Other
information within the last record will also be needed.
 
M

Mike Painter

JANUS1356 said:
I have a huge table (Table X) created from several tables (tables A,
B, C & D) using a MAKE-TABLE query. I need to update this table from
future queries selecting only those new records from the same source
tables and append them to TABLE X everytime a new set of records are
produced by the Make-Table Query. The purpose of keeping the LAST
RECORD from TABLE X is to compare it with the key in future queries
so that those greater than the last highest key would be the ONLY
records to be selected and eventually appended. Other information
within the last record will also be needed.
Click to expand...

There is no need for more than one table unless these tables are being
transmitted from other sources.
If you are setting your own key then you would need to sort on that key and
move to the last record according to that sort.
Or, if you set your own key then you might refer to the way you set that
key. Read the table etc.
 
Top