Report layout

[echofuzz]

Hi!

I have a question about report layout, but I'm having trouble explaining it.
I have a number of Sites with Ratings for specific Findings. I'd like to have
the Findings arranged in a column, then the corresponding Rating for each
Site in a column, as well.

Something like this:

Site1 Site2 Site3
Finding1 Rating Rating Rating
Finding2 Rating Rating Rating
Finding3 Rating Rating Rating

Can anyone give me an idea of how to do it, or a template or sample to work
off of? Or is it just something that Access can't do?

Thanks!

 

[Duane Hookom]

There is a solution for dynamic crosstab reports at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=11. If the sites
are fairly static (don't change) you can create a standard crosstab with the
Column Headings property set to each unique site like:
Column Headings: Site1Name, Site2Name, Site3Name