Well I was trying to keep my example simple. I tried the link, but it does not seem to take care of my problem with the blanks on my report. I think you read my other posts on this project so I will give yous some samples of what I am getting now and what I want to have. Sorry about the formatting.
Records that I am getting:
RECORD 1
Inspector: Jerry Department: Electrical
Date: 4/20/2004 Area: Tranasformer
Total Score: 66
Individual Scores:
Walkways 3 Maintenance Cabinets 1 Safety Latches 3
Platforms 2 Equipment 2 Duct Tape 1
Cabinet Tops 1 Electrical Boxes 3 Paint 3
Inside Cabinets 2 Conduit 1 Masonry 1
RECORD 2
Inspector: Alicia Department: Electrical
Date: 2/25/2004 Area: Drying
Total Score: 65
Individual Scores:
Walkways 2 Maintenance Cabinets 3 Safety Latches 3
Platforms 1 Equipment 1 Duct Tape 1
Cabinet Tops 3 Electrical Boxes 2 Paint 2
Inside Cabinets 2 Conduit 3 Masonry 3
RECORD 3
Inspector: Alicia Department: Natural
Date: 6/29/2004 Area: Dicer
Total Score: 93
Individual Scores:
Walkways 3 Maintenance Cabinets 3 Safety Latches 2
Platforms 3 Equipment 3 Duct Tape 3
Cabinet Tops 3 Electrical Boxes 3 Paint 4
Inside Cabinets 3 Conduit 3 Masonry 3
This is what I am trying to do:
RECORD 1
Inspector: Jerry Department: Electrical
Date: 4/20/2004 Area: Tranasformer
Total Score: 66
Individual Scores:
Platforms 2 Equipment 2
Cabinet Tops 1 Conduit 1
Inside Cabinets 2 Duct Tape 1
Maintenance Cabinets 1 Masonry 1
RECORD 2
Inspector: Alicia Department: Electrical
Date: 2/25/2004 Area: Drying
Total Score: 65
Individual Scores:
Walkways 2 Electrical Boxes 2
Platforms 1 Duct Tape 1
Inside Cabinets 2 Paint 2
Equipment 1
RECORD 3
Inspector: Alicia Department: Natural
Date: 6/29/2004 Area: Dicer
Total Score: 93
Individual Scores:
Safety Latches 2
I have managed to get my reports to look like this:
RECORD 1
Inspector: Jerry Department: Electrical
Date: 4/20/2004 Area: Tranasformer
Total Score: 66
Individual Scores:
Walkways Maintenance Cabinets 1 Safety Latches
Platforms 2 Equipment 2 Duct Tape 1
Cabinet Tops 1 Electrical Boxes Paint
Inside Cabinets 2 Conduit 1 Masonry 1
RECORD 2
Inspector: Alicia Department: Electrical
Date: 2/25/2004 Area: Drying
Total Score: 65
Individual Scores:
Walkways 2 Maintenance Cabinets Safety Latches
Platforms 1 Equipment 1 Duct Tape 1
Cabinet Tops Electrical Boxes 2 Paint 2
Inside Cabinets 2 Conduit Masonry
RECORD 3
Inspector: Alicia Department: Natural
Date: 6/29/2004 Area: Dicer
Total Score: 93
Individual Scores:
Walkways Maintenance Cabinets Safety Latches 2
Platforms Equipment Duct Tape
Cabinet Tops Electrical Boxes Paint
Inside Cabinets Conduit Masonry
As you can see any item value that is >2 is a blank. I would like to get rid of the empty spaces all together. It was suggested to me earlier that I try puting each item in a different heading so that I may hide the headings, but since I have around 25 items I can not do that. My report's source is my cross tab query that I created which basically lists all of my items, inspector, etc. the items values in this query have already been sorted and if the items values are >2 then the value is "". I know this is a big post, but you asked for a more detailed response. Thank you for your help and any more help that you can muster.
-ATray