Simple query help with 2 tables

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Boy I'm really rusty here, haven't used Access for a few
years.
Have one simple (but large) table with 4 fields: date,
time, amount, and cellphone_number_called.

Have another table with 2 fields: employee and
phone_number. This may have numerous listings with the
same employee for his home phone, cell phone, girlfriend's
phone, etc.

I want to query the large table using the small table and
output the calls employees made to these phone numbers,
and total them up, so I can get them to pay for these
personal calls!

Pretty simple deal, but confused by relationships,etc. Can
the wizards help me work thru this without involving any
other program writing?
Thx!
 
Hi,
Not sure you need to worry about relationships with
your two tables. Just create a query and join tables by
phone number fields. It's the only thing you have common
to both tables.
You probably want to create a totals query, group by
employee, group by phone number, sum amount.

HTH
 
Back
Top