If the query is selecting all the records, then you need to use criteria to
select only the one or ones that you want. Create a new SELECT query with
the fields you want, sort by the transaction ID, in descending order, then
right click in the upper portion of the query builder, choose Properties,
and pick "Top 1". Run the SELECT query to assure yourself it only returns
one record. Go back to Query Design view, and on the Menu, choose Query and
select MakeTable. Enter the new table name. It should copy in the same one
record that the SELECT query returned.
Larry Linson
Microsoft Access MVP
"PMB" <pmbragg@megavision.com> wrote in message
news:G4Xmb.44$Mi.27128@news.uswest.net...[color=blue]
> Thank you in advance for any and all assistance.
>
> I'm trying to use a make table query to pull the last transactionID, so I
> can use an append query to reset the transactionID to the next sequential
> number. My problem is, the make table query is taking all the
> TransactionID's and putting them in the new table.
>
> Is there a way to take the last transactionID only and put it in the new
> table? So this way, when I clear the old Transactions, and append the
> TransactionID with an Append Query, the only Transaction there will be the
> last one.
>
> Any and All help would be greatly appreciated!
>
>
>[/color]
