manipulating queries

[Patricia Lynch]

I have a query with 3 fields:
description
count
y1

Y1 is the same value (2006) for all the rows in the query. I'd like to turn
that value into the heading for a column in a new query: example-
Query 1
DESCRIP COUNT Y1
descript1 count1 2006
descript2 count2 2006

Should turn into

DESCRIP 2006
descript1 count1
descript2 count2


Can I do this with a query and if so, how?

thanks for any suggestions

 

[akphidelt]

Yes, create a "Crosstab Query". When you click on Crosstab Query you will see
some boxes that say Group By underneath the fields. Underneat that you will
see some blank cells with Crosstab to the left. Change Y1 to Column Heading,
Count to Value, and Description to Row Heading

Make sure you change the count Total to Sum instead of Group By