Not sure what is wrong with this Query. Can you use two and statments in a query or is it worded differently?
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 [B][COLOR="Red"]LIKE ('R%') AND Extra ='1'[/COLOR][/B]ORDER BY tblJanuary.EOD, SCD, [Last Four]
The bold red is where it is giving me problems and ideas how to fix it.