vba syntax in access 2000

[Guest_imported]

hello,

how can i write vba for select statement for integer and string after WHERE clause as folows:

Dim employeeID as integer
Dim employeeName as String
employeeID=55
employeeName="ahmed"

RecSet.openrecordset("SELECT MAX(ID) as bid,EmpID,EmpName WHERE EmpID=employeeID AND EmpName=employeeName
GROUP BY EmpID,EmpName

the green color endicate for integer in WHERE condition
the red color endicate for string in WHERE condition

 

[CPUburn]

hi,

try:

RecSet.openrecordset("SELECT MAX(ID) as bid,EmpID,EmpName WHERE EmpID=" & employeeID & " AND EmpName= '" & employeeName & "' GROUP BY EmpID,EmpName)

grtz

CPUburn

 

[Databaseguy]

CPUBurn is right, you've gotta concoctenate the string. I usually do it like this so it's a little easier to read & maniplulate.

StrSQL = "SELECT MAX(ID) as bid,EmpID,EmpName WHERE EmpID=" & employeeID & " AND EmpName= '" & employeeName & "' GROUP BY EmpID,EmpName

RecSet.openrecordset(srtrSQL)

Also, the Where clause can be tricky, it likes a lot of parentheses for some reason. Ex: WHERE (((tblYOurTable.FieldName)=" & YourVariable & &quot)"