Assigning the result of a Max() Function to a variable

[Micron]

Do they need to know the calculated value at the outset? I would think that is key.

[ArviLaanemets]

Can you really use SQL like that?

Sorry! Had my attention on query part entirely.

Set NextAppID = (SELECT TOP 1 ApplID FROM tblApplicant ORDER BY ApplID DESC)+1
or
Set @NextAppID = (SELECT TOP 1 ApplID FROM tblApplicant ORDER BY ApplID DESC)+1

[Welshgasman]

I cannot get that to work.
If the variable is long I get sql1, if I remove the quotes I get sql 2, and if I change the variable to an object I get sql3

[June7]

What was your solution?

Did you see the posts that suggested using DMax()?

Arvil, did you test your suggestion? Works for you?

[CJ_London]

I would have thought the correct syntax would be

NextAppID = currentdb.openrecordset("SELECT TOP 1 ApplID FROM tblApplicant ORDER BY ApplID DESC")(0) + 1