Search criteria in a query 1

[infact]

I set up a query using two tables (table1, table2). Since these are joined, can I get records off of table 1 by setting up a search criteria referencing a field in table 2 ? (Ex. if date in table1 equals getdate in table2).
Thanks.

 

[PHV]

[tt]Field Date
Table table1
Criteria =table2.getdate[/tt]

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