Getting fields to display as rows

  • Thread starter Thread starter Christine Ronning
  • Start date Start date
C

Christine Ronning

Hi,

I am happy with my table structure in Access with my fields and query
abilities.

However it would make my information much clearer if I could display it on a
rotated access (fields as rows) in a report. Is there any way to do this?

Thanks
Christine
 
Have you looked at using Cross-Tab Queries (or Pivot Tables, in Access 2002
or later) to do this? It's not a "standard formatting option" in Reports, so
you'd have to arrange the data properly to feed the report.

Larry Linson
Microsoft Access MVP
 
Back
Top