www.webdeveloper.com
Results 1 to 3 of 3

Thread: Problem with query need another set of eyes

  1. #1
    Join Date
    Oct 2006
    Posts
    392

    Problem with query need another set of eyes

    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.

  2. #2
    Join Date
    Jul 2004
    Posts
    300
    What happens with this?
    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 tblJanuary.Extra ='1' ORDER BY tblJanuary.EOD, SCD, [Last Four]
    Any chance you can post the error message?

  3. #3
    Join Date
    Oct 2006
    Posts
    392
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles