Ade F
Avid Listener
- Local time
- Today, 13:54
- Joined
- Jun 12, 2003
- Messages
- 97
Counting same IDS
Here is a question for all you query experts,
Just say I have two tables
Job number ID (Pri Key)
Job Description etc
Customer ID (Pri Key) (IS a sub of job number continues form)
Name etc
How would I count how many instances of customer id's occur under the specific job number?
Basically I would like for my report to show how many customers have been logged to the specific job number. At the moment I have a unique ID box showing the customer id.
Yes I may be being a little vague but I'm sure you know what I mean.
A job number can have many customers. The customer has a unique ID but I do not wish to know the unique ID but how many unique ids starting from 1 there are within that specific job.
Any ideas?
Here is a question for all you query experts,
Just say I have two tables
Job number ID (Pri Key)
Job Description etc
Customer ID (Pri Key) (IS a sub of job number continues form)
Name etc
How would I count how many instances of customer id's occur under the specific job number?
Basically I would like for my report to show how many customers have been logged to the specific job number. At the moment I have a unique ID box showing the customer id.
Yes I may be being a little vague but I'm sure you know what I mean.
A job number can have many customers. The customer has a unique ID but I do not wish to know the unique ID but how many unique ids starting from 1 there are within that specific job.
Any ideas?