comparing date values in a query (Access2000)

Topic

New Reply

I am trying to compare two date fields in a query. I want a=b (where field ‘a’ from table 1 is equal to field ‘b’ from table 2) then return the datevalue that is true for the query. These two fields are joined by corresponding system numbers.
How should I proceed?

Reply | Quote

Replies

If the two tables are linked by the system number, there is no need to display the number twice or the date twice. Open your query in “Sql view” and use this sql (rename the fields and tables to match yours):
SELECT Table1.SysNum, Table1.dateA
FROM Table1 INNER JOIN Table2 ON Table1.SysNum = Table2.SysNum
WHERE (((Table1.dateA)=[Table2].[dateB]));

Reply | Quote

Thanks, I think we have a winner here!!
Seems like I am getting the data that I am looking for.
I really appreciate the help!!

Reply | Quote