Crosstab query -- column headings

  • Thread starter Thread starter Perry Kew
  • Start date Start date
P

Perry Kew

I have a database with three fields and looks like this:

Year Name Points
2000 Tom 12
2000 Burt 65
2002 Tom 8
2003 Tom 12
2002 Ray 48
2001 Tom 14
2003 Tom 8

Is there any way to do a cross tab query so that I can get:
Tom Burt Ray
2000
2001
2002
2003

The value in the Crosstab should give the number of points
earned by each man by year.

Thank you for your help.

--Perry
 
Yes,

Create a new crosstab query,

Select the Year, Name, and Points fields (BTW, Year and Name are
Access reserved words and should not be used as field names).
In the Crosstab row of the query, select RowHeading for Year, Column
Heading for Name, and Value in the Points column. Then, in the Totals
row, make sure that Year and Name are set to GroupBy and Points is set
to Sum.

--
HTH

Dale Fye


I have a database with three fields and looks like this:

Year Name Points
2000 Tom 12
2000 Burt 65
2002 Tom 8
2003 Tom 12
2002 Ray 48
2001 Tom 14
2003 Tom 8

Is there any way to do a cross tab query so that I can get:
Tom Burt Ray
2000
2001
2002
2003

The value in the Crosstab should give the number of points
earned by each man by year.

Thank you for your help.

--Perry
 
Dale, thank you very much for your clear directions. This
is what I was looking for.

--Perry
 
Back
Top