Null value or Certain Codes

[jdgreen]

I have a query that searches two tables. I want results if there is no value for a persons last name in the second table of if the attendance code is either a FWP or PA in the second table. The key value is the Clock Number, which I have the two tables joined by.

John Green

 

[traingamer]

Will there always be a linked record in the second table? i.e. There is a record, but it has no value in the [lastname] field.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[jdgreen]

No, that's the problem. I worked it out using an IsNull function to get the names that don't show in the date range for the second table, but can't figure out how to get it with the two codes that should also be included.

John Green

 

[PHV]

What is your actual SQL code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886