Grouping Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure how to achieve the following.

I have 4 rows in a table with headings of ProjectID, ProjectType,
ProjectStatus

The data is:

1, Rectification, Live
2, Discretionary, Live
3, Discretionary, Dead
4, Rectification, Dead

I want to put this information on a report with ProjectType as column
headings, ProjectStatus as row headings and ProjectID at the appropriate
intersecting point (see below)

Rectification Discretionary
Live 1 2
Dead 4 3

Help please!
 
See crosstab for help, or search crosstab access database from this site,
Some one have similar question and has been answer.
 
Back
Top