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
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