Count within a group

jake7363

Registered User.
Local time
Today, 19:53
Joined
Mar 14, 2005
Messages
46
Hi,
In my Summary report, there are two groups: jobNo within Category.
jobNo contains data which can be repetative, but not for all records.
In other words, there can be:
6 records with jobNo 1234,
2 records with 4567 and
1 record for 9701.

I want to count the number of times that jobNo changes, but not the total number of jobNo records. I tried a query using an expression Max(jobNo), then tried to sum it in the report, but it gives the total number for jobNo's. How can I achieve the result I am seeking?


Thanks in advance,
Jake
 
check out the unique propery of a query this equates to the DISTINCT keyword
 
re Count within a group

I'm not sure I follow - if I use DISTINCT within the query, then I will get only those records for that number, but I want all the records, only I want to count the number of times the jobNo changes.

Please explain..
 
Select distinct [JobNumber] etc will give the number of different job numbers not the total number of job numbers. What do you expect from your example, as you may require to group by jobNumber and count the number of occurrences.
 

Users who are viewing this thread

Back
Top Bottom