squishiful
Programmer
I am new to Access. I have very little of an idea of what I am doing. Okay, here goes...
What I have is two tables
One with customer info I need to compare the ID field to another table so I'll only show that field.
I have another table with jobs I've done this has a for field that tells the ID of the customer this job was for, I'm not sure if you'll need the ID of these but I'll show it anyway.
I now want to compare the two tables and find out how many jobs I've done for each customer so I want the output to be sumthing like:
Is there anyway that I can do this?
Thank you!
What I have is two tables
One with customer info I need to compare the ID field to another table so I'll only show that field.
Code:
ID
--
1
2
I have another table with jobs I've done this has a for field that tells the ID of the customer this job was for, I'm not sure if you'll need the ID of these but I'll show it anyway.
Code:
ID FOR
-- ---
1 1
2 1
3 2
I now want to compare the two tables and find out how many jobs I've done for each customer so I want the output to be sumthing like:
Code:
CUSTOMER JOBS
-------- ----
1 2
1 1
Thank you!