Matrix report

  • Thread starter Thread starter Ynot
  • Start date Start date
Y

Ynot

Has anyone tried to develop a matrix report from Access. I would like to do
something like that but have no idea where to start.



What I want to do is have a list of projects on the vertical access and if a
task exists for that project put an X in a box on the horizontal access. I
know I could easily type a report like this in Excel but is there a way to
use the data in my Access table to produce it?
 
Are you expecting us to understand your Access table structure or just make
a guess? I think you could use a crosstab query. Have you checked these out?
 
Duane,

First thank, all I was looking for were some ideas on how to do this. I
will lookup crosstab query but for other ideas here is a simplistic view of
the 2 tables.

For purposes of my report the table structure is simple, a job table, which
is primary and a "phase" table which is secondary and is populated by
selection from a fixed list of entries. Any job can have one or many
phases, an individual phase can only be assigned to an individual job. e.g

job 100
layout
stem
plumb
slab
Job 101
layout
canceled
job 102
layout
basement
stem

Thanks for the idea.
 
A crosstab should work. You can use the Phase as the column heading and set
the Column Headings property to all possible Phase values.
 
Duane,

Thanks again. I need some work to get it to do what I want but I didn't
know about a crosstab query. I used the wizard to do a crosstab based on
one of my existing queries and got real close to what I am looking for. I
can work this from here......

THANX!
Tony
 
Back
Top