Crosstab workings

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

I have a query which is used to create basic LxBxD for two types of items. I
am wanting to run a crosstab query so that it can 1) display the results as

Type 1 Type 2 Varaince
L 5 8 37.5%
B 9 8 -12.5%
D 10 13 23%
LxBxD 450 832 45.9%

Is this possible to create? i am hoping to just get the first two headings
so i can then run a varaince calculation to work out the difference between
each. Other if anyone else has a idea how to do this then i am open to
suggestions


Thank you
 
I have a query which is used to create basic LxBxD for two types of items. I
am wanting to run a crosstab query so that it can 1) display the results as

Type 1 Type 2 Varaince
L 5 8 37.5%
B 9 8 -12.5%
D 10 13 23%
LxBxD 450 832 45.9%

Is this possible to create? i am hoping to just get the first two headings
so i can then run a varaince calculation to work out the difference between
each. Other if anyone else has a idea how to do this then i am open to
suggestions


Thank you
Click to expand...

It would help more than a little bit if you were to post some description of
the query upon which you want this result based.

I'm guessing yes, but not knowing anything about what's in the base data, nor
what L, B, and D might be, it's just a bit hard to be specific.
 
the information relates the construction of a ship. L = Length, B = Beam, D =
Depth. I have basic guidelines of the sizes of the vessels but wanting to use
these sizes so can work out the difference in a query, and apply indicies for
escalting up the price for work. Is it possible to produce a crosstab which
does this or am i going to have to write it in SQL?
 
the information relates the construction of a ship. L = Length, B = Beam, D =
Depth. I have basic guidelines of the sizes of the vessels but wanting to use
these sizes so can work out the difference in a query, and apply indicies for
escalting up the price for work. Is it possible to produce a crosstab which
does this or am i going to have to write it in SQL?
Click to expand...

Should be doable in a crosstab query. Use the Type as the Column Header. You
might need to calculate the product LxBxD in a separate query, or in the
Footer of a report.

Note that if you "produce a crosstab" then you *will* be "writing it in SQL" -
all queries are in SQL; there are just some tools that make writing the SQL
easier, such as the query grid or the wizards. I'd start with a wizard
generated crosstab, view it in SQL, and tweak from there.
 
Back
Top