Search results

Many Thanks MailMan, Access QBE is throwing a missing operator error in the part (tbluser.AltTask = JL1.[Task Code]) AND (tbluser.AltBudget = JL1.[No]) LEFT JOIN tblJobList AS JL2 ON (tblEmployeeList.[Home Task] = JL2.[Task Code])...

Hi Mailman, Thanks for that - it's great in that it pulled a record from the Phone Users with a project and task code combiniation that does not exist on their employee listing, but I'd like it to also look at AltBudget and AltTask in tblUser to see that if they are not null (ie user has...

Hi Mailman. Points noted about formatting of SQL and use of special characters. I copied the code above and it's no different to what I had in the notepad document, that I could see anyway, and returned no results, not picking out the one result I am expecting. Many Thanks Graham

Hi, Many Thanks For Your Suggestion, however the query still returned no results when I hard coded data. Please see the attached file for my test data. You will see that in tblUser I have hard coded an alternative task and budget combination that do not exist in tblJobList, so in the results...

Hi All, I have a database of our company's mobile phone users. In it are several tables, one - tblEmployeeList a complete employee list with each employee's perpetual Project code and task code. a 2nd - tblJobList table with 2 columns for all the possible combinations of project code and...