Combine tables with duplicates

[emmy]

I have 2 tables, PhoneAccounts and PhoneInventory. PhnoneInventory has Primary Key "PhoneNumber" (no Dupes). PhoneAccounts has PrimaryKey "PnoneNumber" (Dupes OK). PhoneAccounts does have some duplicate phone numbers because one phone may be paid for by 2 grants. I need a query that will combine the 2 tables and show the phone numbers that are paid for by 2 different grant numbers. What I get is the phone number record twice, but with the first grant number in both records. The tables have different fields, which made a union query difficult.
Thanks for any help!

 

[CajunCenturion]

What does your current query look like?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[emmy]

You know what? When In pasted in the code and started writing an explanation... I realized my error. I was pulling the phone number & grant info from the ONE table rather than the MANY table. Good grief. Just goes to show, sometimes it's good to walk away for awhile!

Thanks for asking!!!!