Help with SQL code

[George Too]

Hello All,

The following SQL statement is promting the user to enter machine number. Why? If I remove that part of the statement then it works fine.

SELECT tblData.* FROM tblData WHERE tlbData.[Machine] IN('WH3') AND tblData.[Project] Like '*' AND tblData.[Repeat] Like '*' AND tblData.[Run_Date] Like '*';

Any input is appreciated.

Thanks,
Geo Too

 

[ejstefl]

Is it because you typed tlb instead of tbl?

 

[George Too]

You have no idea how many times I proof read this thing...Thanks. Now off to the eye doctor