Not equal to query

[patchesohouli]

Hi,

I have one [Master Query] with employee ids, pay frequencies (biweekly 1, biweekly 2) and paycheck issue dates. I also have a second query [Biweekly1 PayDates] that gives me the biweekly 1 paycheck issue dates. Essentially that query returns two paycheck issue dates for me.
I want to create another query that gives me individuals with a biweekly1 frequencies and paycheck issue dates NOT EQUAL (<>) to the two paycheck issue dates from [Biweekly1 PayDates].

This is my sample data, and it is not working.

SELECT [Master Query].[Empl ID]
FROM [Master Query] INNER JOIN [Biweekly1 PayDates] ON [Master Query].[Pay Frequency] = [Biweekly1 PayDates].[Pay Frequency]
WHERE ((([Master Query].[Paycheck Issue Date])<>[Biweekly1 PayDates].[Paycheck Issue Date]))
GROUP BY [Master Query].[Empl ID];

Thanks for your help

 

[The_Doc_Man]

Why is it not working? What is it doing that is wrong? Are we talking about errors, wrong results, no results, etc. ?

Please remember that "not working" could even describe comic-strip character Beetle Baily (when Sarge isn't around...), so it isn't THAT specific of a problem description.

 

[sneuberg]

Typically when you want records that are in one table or query that are not in another table or query you have an unmatched query situation. I'm not sure if that what you are trying to do but I suggest read the material in following links to see if this might apply to your situation.

http://datagnostics.com/dtips/findunmatched.html
http://blogannath.blogspot.com/2010/03/microsoft-access-tips-tricks-find.html

Also a subquery might help. Suggest reading the "Identifying what's not there" section of:

http://allenbrowne.com/subquery-01.html