One-to-Many join act as a One-to-One join

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Is there a way to make a one-to-many join act as a one-to-one join?

Sometimes I have two tables or two queries or a table and a query that have
a one-to-many relationship between them. Sometimes the two are joined on a
single field but sometimes they are joined on two or three fields. And
sometimes instead of getting many records returned from the second table I
only want one record returned from the second table.

For example, the first table has 78 records and the second table has 352
records and every one of the 352 records joins to one of the 78 records in
the first table. Now, instead of getting all 352 records returned I only
want 78 records returned from the second table.

I know I can write a VBA routine to do this but I was wondering if this is
possible using just a query.

Thanks.
 
Use a query on table two to limit the records - latest date, highest number,
etc. and use in the join instead of the table directly.
 
Back
Top