How to get pass number varible in the sql query in where option

[nitintiwari]

pls help

In Table X (Of MsAccess DAtabase)
Y = Numbers

Query = Select Z,Y from X where Y= ?

Wherever i pass a var in y it gives me data type mismatch error ]
pls help

[willakawill]

pls help

In Table X (Of MsAccess DAtabase)
Y = Numbers

Query = Select Z,Y from X where Y= ?

Wherever i pass a var in y it gives me data type mismatch error ]
pls help

What is the variable type in the database? In design mode if you click on the name of the field you will see in the properties box below.e.g. Long Integer
The variable you pass in the query must match this type.

Dim lngY As Long
Dim stQuery As String
 
lngY = 12345
stQuery = "SELECT Z, Y FROM X WHERE Y = " & lngY
 

[nitintiwari]

What is the variable type in the database? In design mode if you click on the name of the field you will see in the properties box below.e.g. Long Integer
The variable you pass in the query must match this type.

Dim lngY As Long
Dim stQuery As String
 
lngY = 12345
stQuery = "SELECT Z, Y FROM X WHERE Y = " & lngY
 

thanx it never clicked me u can do this thanx a lot sometime ur get blocked