Substract columns from a crosstab table

[Guest]

Hi,

I have a historical event list of different statuses for an individual
record, where events follow one after other and recorded.
The result of the crosstab query looks like this:
read assigned completed
date: 1/12/06 12 7 5
1/13/06 24 20 1

what would be the best methodology to get the count of the records that were
read but not assigned:
(read) - (assigned) for each datestamp?

Thanks,

Erika

 

[Guest]

Create a select query using the crosstab as source and add an output field
like this -- Additional Reading: [read] - [assigned]

 

[Guest]

Thank you,

This solved the problem.

Create a select query using the crosstab as source and add an output field
like this -- Additional Reading: [read] - [assigned]

Hi,

I have a historical event list of different statuses for an individual
record, where events follow one after other and recorded.
The result of the crosstab query looks like this:
read assigned completed
date: 1/12/06 12 7 5
1/13/06 24 20 1

what would be the best methodology to get the count of the records that were
read but not assigned:
(read) - (assigned) for each datestamp?

Thanks,

Erika