Easy 250 points – Passing a variable to

What is the d*** syntax to pass a variable to an SQL statement.

For example:

I want to know the number of records that exist in the RollCallData table for an employee number entered into Text1

empnum = Text1.value

SELECT * FROM tblRollCallData WHERE EmployeeNumber = empnum;

I can make it work if I enter the employee number directly in the SQL statement, but I can’t seem to pass the variable ’empnum’ to the SQL statement

Should be an easy 250 points for somebody.

Thanks