G
Greg Green
Basic Concept:
I'm interested in subtracting the result of one Crosstab Quey from another
crosstab wherein there is a record for each of the 24 hours of the day. I'd
like to use Select queries with Crosstabs as a subqueries. I would use two
Select queries of Crosstabs, then a third query which joins the enumeration
of the 24 hours and subtracts, hour by hour.
Actual Execution
There are actually 9 or so queries, layered atop one another. Four Crosstabs
enumerate base data (24 hours). Other Select Queries of this data are then
joined to do some addition, subtraction, and multiplication. Working with
all the columns, the queries are huge and the formatting results very
unpredictible.
Question
Is there an easier way to unite crosstabs and do multiple arithmetic
operations? I have to do alot of this.
Thanks in advance - Greg
I'm interested in subtracting the result of one Crosstab Quey from another
crosstab wherein there is a record for each of the 24 hours of the day. I'd
like to use Select queries with Crosstabs as a subqueries. I would use two
Select queries of Crosstabs, then a third query which joins the enumeration
of the 24 hours and subtracts, hour by hour.
Actual Execution
There are actually 9 or so queries, layered atop one another. Four Crosstabs
enumerate base data (24 hours). Other Select Queries of this data are then
joined to do some addition, subtraction, and multiplication. Working with
all the columns, the queries are huge and the formatting results very
unpredictible.
Question
Is there an easier way to unite crosstabs and do multiple arithmetic
operations? I have to do alot of this.
Thanks in advance - Greg