Populate variable using SQL

[Al]

I want to populate a variable, MaxID, with the highest ID
in the PROJECT table. The ID field is an Integer. I want
to add 1 to MaxID, place a text prefix on it of "PM" and
insert it back into the PROJECT table in a PMID text field
(This will be used to link it to a Public Meeting record
in another table)

How do I populate the MaxID variable? (Access 2000)

TIA,
Al

[Al]

Sorry, I meant to post this under access.formscoding.
My mistake...

-----Original Message-----
I want to populate a variable, MaxID, with the highest ID
in the PROJECT table. The ID field is an Integer. I want
to add 1 to MaxID, place a text prefix on it of "PM" and
insert it back into the PROJECT table in a PMID text field
(This will be used to link it to a Public Meeting record
in another table)

How do I populate the MaxID variable? (Access 2000)

TIA,
Al
.

[Herfried K. Wagner [MVP]]

"Al" <ak******@ci.tulsa.ok.us> schrieb:

I want to populate a variable, MaxID, with the highest ID
in the PROJECT table. The ID field is an Integer. I want
to add 1 to MaxID, place a text prefix on it of "PM" and
insert it back into the PROJECT table in a PMID text field
(This will be used to link it to a Public Meeting record
in another table)

How do I populate the MaxID variable? (Access 2000)

This is a VB.NET language group. Please turn to the ADO.NET newsgroup:

news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://msdn.microsoft.com/newsgroups...amework.adonet

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[William Ryan]

Use cmd.ExecuteScalar with commandtext like
SELECT 'PM' + Convert(Varchar(MAX(ID) + 1))
"Al" <ak******@ci.tulsa.ok.us> wrote in message
news:20****************************@phx.gbl...

I want to populate a variable, MaxID, with the highest ID
in the PROJECT table. The ID field is an Integer. I want
to add 1 to MaxID, place a text prefix on it of "PM" and
insert it back into the PROJECT table in a PMID text field
(This will be used to link it to a Public Meeting record
in another table)

How do I populate the MaxID variable? (Access 2000)

TIA,
Al