"simple" crosstab report

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi

trying to do a very simple (or so i thought) crosstab report - i've had a
look at the samples at http://www.invisibleinc.com and these are great but
way more complex than i need, i've also tried writing the sql for the report
myself but have got stuck at how to list items in the PIVOT bit.

i have a table (tbl_summary) with three fields
s_code
s_type
s_value

s_code can be up to 50 different items - so i want these as the row headings
s_value i want to sum
and
s_type can be one of seven items and i'ld like all six items to appear on
all reports - but, of course, with only the values listed under them where
applicable. These seven types are "Spiral", "Tester", "Internal",
"External", "Accept", "Seal Coat" and "Reject"
-wish list item - is a total for each code (another column after "Reject")

could someone please assist me in writing the sql needed to create this
pivot table - or point me in the general direction.

Cheers
JulieD
using Ver 2000
 
Hi Julie,
I created the samples from invisible, inc. I believe you don't need anything
that complex.

Create the Crosstab query as you have noted and set the Column Headings
property to
Column Headings: "Spiral", "Tester", "Internal", "External", "Accept", "Seal
Coat", "Reject"

You can then create a report based on the crosstab.
 
Hi Duane

thanks for this - couldn't figure out how to set the column headings
property until i found an old post by John Vinson ... which helped me(along
with your information) achieve the reports i needed. Thanks again.

Regards
JulieD
 
Back
Top