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

[Guest]

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.

 

[Joseph Meehan]

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.

Frankly I am not at all sure what you problem is.

I do have one question. Are you sure you want to do what you are doing?
It sounds like you are doing something the hard way. It seems that if you
maintained the A,B,C&D tables and used a query to bring the data together,
you would not need this additional table. Of course I could not understand
what you are really doing.

 

[Mike Painter]

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.

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.