By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Make Table Query HELP & Append only 1 ID

P: n/a
PMB
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!

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <pm*****@megavision.com> wrote in message
news:G4***************@news.uswest.net...
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!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.