PDA

Click to See Complete Forum and Search --> : Problem with query need another set of eyes

landslide
05-01-2007, 03:20 PM
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 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.
mattyblah
05-01-2007, 05:08 PM
What happens with this?

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]


Any chance you can post the error message?
landslide
05-01-2007, 05:10 PM
Im a moron I had no records matching that expression thats why it was not working thanks for your help.Looks like it work fine sorry.