Not sure what is wrong with this Query. Can you use two and statments in a query or is it worded differently?
Code:
SELECT tblJanuary.SSN, tblJanuary.EOD, [tblJanuary.Last four], tblJanuary.firstname, tblJanuary.lastname, tblJanuary.ORGCODE, tblTollFreeEmployees.SCD, tblJanuary.SEID, tblJanuary.jan2, tblJanuary.Extra, tblJanuary.timestamp1
FROM tblJanuary, tblTollFreeEmployees
WHERE [tblTollFreeEmployees.SEID] = [tblJanuary.SEID] and tblJanuary.jan2 LIKE ('R%') AND Extra ='1'ORDER BY tblJanuary.EOD, SCD, [Last Four]
The bold red is where it is giving me problems and ideas how to fix it.
SELECT tblJanuary.SSN, tblJanuary.EOD, [tblJanuary.Last four], tblJanuary.firstname, tblJanuary.lastname, tblJanuary.ORGCODE, tblTollFreeEmployees.SCD, tblJanuary.SEID, tblJanuary.jan2, tblJanuary.Extra, tblJanuary.timestamp1
FROM tblJanuary, tblTollFreeEmployees
WHERE [tblTollFreeEmployees.SEID] = [tblJanuary.SEID] and tblJanuary.jan2 LIKE 'R%' AND tblJanuary.Extra ='1' ORDER BY tblJanuary.EOD, SCD, [Last Four]
Bookmarks