Joined tables on unique ID gives correct results from one table but only first result from other

[jsher]

Hi I'm a newbie here and also with Access. I've constructed a query using two tables: each with a unique client ID number and a date. One is called Contacts (4543 records) and the other called Referrals (3767 records). The time span for the dates is from 01 April 2014 to 31 October 2015. Each client who makes a contact is given a unique ID number and a contact date. If the client is subsequently referred, the same ID number is used in the Referrals table and the date of referral is recorded. Most clients have only one contact and one referral but others can have multiple contacts and referrals.
I'm trying to match the two tables using the ID number as the common variable and want to make a table that shows the contacts ID and date and the Referrals ID and date. The result is fine where clients have single contact and referral. Where mutiple contacts occur the results show each Contact date correctly but only the first Referral date. I've tried using totals and first and last but all either under-report or over report the results. Can anyone help please?

Thanks

[CJ_London]

you'll need to show your table structure and some sample data to demonstrate the problem

[June7]

Say a client has 2 contacts (how can there be more than 1?) and 3 referrals, a join on just the ContactID keys should result in 6 records.

Post the SQL statement of the query.

If you want to provide db follow instructions at bottom of my post.