Substract columns from a crosstab table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Create a select query using the crosstab as source and add an output field
like this -- Additional Reading: [read] - [assigned]
 
Thank you,

This solved the problem.

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

etf said:
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
Click to expand...
Click to expand...
 
Back
Top