help with simple query plz?

  • 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,
print all the sorted lists, 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!
 
SELECT PhoneCallsTable.[Date], PhoneCallsTable.[Time],
PhoneCallsTable.[Amount], PhoneCallsTable.[cellphone_number_called],
EmployeeTable.[Employee]
FROM PhoneCallsTable INNER JOIN
EmployeeTable ON PhoneCallsTable.[cellphone_number_called] =
EmployeeTable.[phone_number];
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top