Only Command in Access

[Stevestan1]

Hi, I have two matching columns in two tables. The first column contains a unique transaction number while the second column is the date associated with the transaction. I would like to connect the two tables so that it returns only the transactions that are in both tables and where the date in table 1 is greater than the date in table 2. Is there an "only" command in Accesss which will allow me to do this?

[nico5038]

Just use the Criteria below the date of table2 to indicate it should be > as the date of table1.

Best to read first the Access Help about Queries.

Nic;o)

[NeoPa]

Nico is right of course. Something to help with the linking of the tables is SQL JOINs.