DistinctRow or DistinctID

[NinasNumber via AccessMonster.com]

i am using Access2000 and want to create a querie that will reference
information from each field and record only once from 2 talbes. They have a
common field of bill date and CBR#, other fields are not common.

 

[David S via AccessMonster.com]

i am using Access2000 and want to create a querie that will reference
information from each field and record only once from 2 talbes. They have a
common field of bill date and CBR#, other fields are not common.

Do [bill date] and [CBR#] form the unique key of both tables, or are there
multiple records for each combination of these values in one or both tables?

Would it be true to say that if Table1 had additional fields [Hours worked],
[Location Worked] and Table2 had [Rate per Hour], [Billing Owner] that you
want your output to be:
[bill date], [CBR#], [Hours worked], [Location Worked], [Rate per Hour],
[Billing Owner] ?

 

[NinasNumber via AccessMonster.com]

i am using Access2000 and want to create a querie that will reference
information from each field and record only once from 2 talbes. They have a
common field of bill date and CBR#, other fields are not common.

Do [bill date] and [CBR#] form the unique key of both tables, or are there
multiple records for each combination of these values in one or both tables?

The primary key is an auto-increment ID. There is a many to many
relationship between the tables.

Would it be true to say that if Table1 had additional fields [Hours worked],
[Location Worked] and Table2 had [Rate per Hour], [Billing Owner] that you
want your output to be:
[bill date], [CBR#], [Hours worked], [Location Worked], [Rate per Hour],
[Billing Owner] ?

There is a field in table one that has adjustments, however, since there are
multiple bills sometimes in table one for the same owner, the adjustments
could be a subtotal of any combination of records in table two which has the
adjustment explanation in detail.