Help on SELECT WHERE ID is Access auto numer

[xfile]

Hi:

Could someone kind enough to tell me what is the proper expression for using
SELECT and a conditional criteria for the auto numbered primary key in
Access database, as I have tried to find so long but unsucessful.

The following is the code example where ID is the Access database
autonumbered primary key field, and & AutoNo & is value from ASP form.

"SELECT * FROM tb1ABC WHERE ID='" & AutoNo & "' ",Cn,3

I understand that single quote maybe incorrect for number, but I could not
find, otherwise, what is correct for long integer and auto number.

Thanks so much.

 

[Andi Mayer]

Hi:

Could someone kind enough to tell me what is the proper expression for using
SELECT and a conditional criteria for the auto numbered primary key in
Access database, as I have tried to find so long but unsucessful.

The following is the code example where ID is the Access database
autonumbered primary key field, and & AutoNo & is value from ASP form.

"SELECT * FROM tb1ABC WHERE ID='" & AutoNo & "' ",Cn,3

I understand that single quote maybe incorrect for number, but I could not
find, otherwise, what is correct for long integer and auto number.

for numbers leave the quote out

 

[Van T. Dinh]

"SELECT * FROM tb1ABC WHERE ID=" & AutoNo, Cn, 3

 

[xfile]

Hi:


Thanks so much for both of you

Got it and approaching to the end

Thanks again.