asked on
Querying a database to find where two fields are not equal
I'm sure I'm missing something obvious....
The task at hand:
Create a date driven report that shows everything that has been published within that date range that was supposed to publish in a different quarter (so it was either advanced or delayed)
Select Autonumber, Topic, Quarter: DatePart('q',Date_Posted),
from TableStuff
Where the two date parts don't equal....
How do I write that WHERE clause?
The task at hand:
Create a date driven report that shows everything that has been published within that date range that was supposed to publish in a different quarter (so it was either advanced or delayed)
Select Autonumber, Topic, Quarter: DatePart('q',Date_Posted),
from TableStuff
Where the two date parts don't equal....
How do I write that WHERE clause?
Microsoft AccessSQL
Last Comment
MedscapeEditorial
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
PERFECT!! Thank you for sparing me the headache ....was just pulling a blank on this one!!
ASKER
Another great answer! Thank you for the prompt assistance