Appending record with highest number into table

**MTSPEER** · 05-16-2017, 05:51 AM

I am able to run Query 2, but not Query 1

**MTSPEER** · 05-16-2017, 06:03 AM

I can get Query2 to run, but not Query 1

**JoeM** · 05-16-2017, 06:38 AM

I just noticed that is looks like you have an extra parenthesis in that statement (before the word TransactionDate), and I copied that part from your code. I don't think that should be there.
Try:

Code:

SELECT Max(dbo_AET_DTRR_T.TransactionDate) AS MaxOfTransactionDate
FROM dbo_AET_DTRR_T;

**MTSPEER** · 05-16-2017, 07:32 AM

I noticed that. It works now. thank you!

**JoeM** · 05-16-2017, 07:34 AM

You are welcome!

Appending record with highest number into table

Thread Tools

Similar Threads

Trying to get highest number in a field (LoadTested) for todays date.

Running Query that will return next highest number in table on form

appending a new record in an access table to another table

appending record ID numbers from PK table to the related FK in another table

Code for appending a single record from one table to another table

Posting Permissions