C
Chris S
We have created an Access query that does an inner join on two tables. For
question purposes, Table AAA has a Field PID (Primary Key, unique) and Field
Name. Table BBB has Field PID and Field Date. We join based on Field PID.
When Table BBB has more than one record related to a record in Table AAA, the
resultant query returns all records. We want one record for each PID value,
and for those that have multiple related records in Table BBB, we only want
to the record with the most recent date in the Table BBB Field Date column.
How do we do this in an Access Query?
Chris S
question purposes, Table AAA has a Field PID (Primary Key, unique) and Field
Name. Table BBB has Field PID and Field Date. We join based on Field PID.
When Table BBB has more than one record related to a record in Table AAA, the
resultant query returns all records. We want one record for each PID value,
and for those that have multiple related records in Table BBB, we only want
to the record with the most recent date in the Table BBB Field Date column.
How do we do this in an Access Query?
Chris S