Need to Append only the last record from 1 table to another

[Dave14867]

Hello all,

I am trying to append a record from 1 table to another and I am having issues, it appends all of the records currently.

This is the current SQL statement,

INSERT INTO [Inventory Transactions] ( DHRID, ProductID, [DhrLot #], TransactionDate, TransactionDescription, UnitsReceived, SerialNum )
SELECT DISTINCTROW [Work Orders].DHRID, [Work Orders].PartID, [Work Orders].DHRNumber, [Work Orders].StartDate, [Work Orders].DHRDescription, [Work Orders].Qty, [Work Orders].SerialNum
FROM [Work Orders]



This does a fine job of appending all of the records but I only need the last record.

Thanks

Dave

[ranman256]

You need an identifier for the last record.
do you have an autonumber? Then it will be the largest #.
Make Q1 to get the largest #:
select ID, Max(ID) from table.

then Q2 add it with an append query using Q1:
insert into table2 (fld1, fld2) select ID, name from table1 ,Q1 where table1.ID=Q1.ID

[Dave14867]

ranman256,

Can I do that in the query design? I have the last ID but don't understand how to incorporate that into the original within the design mode,

Correction ; I got it to work fine

[ArviLaanemets]

The basic query is (Assumed KeyField is field/combination of fields, which is growing for later entries)

INSERT INTO SourceTable
SELECT TOP 1 * FROM TargetTable
ORDER BY KeyField Desc