Date Query

[Kris via AccessMonster.com]

I am having difficulty running a simple date query. I have two tables and
they both have target date and completion date columns. I am trying to
build a query that shows items completed past the target date. Any help
you can provide is greatly appreciated.

 

[Ken Snell [MVP]]

A generic query:

SELECT * FROM Tablename
WHERE TargetDate < CompletedDate;