How do I create a report with headers in a row?

[Michele E]

I want a report which has a lot of information given per each day of the week.
I want to far left column to print only once with the corresponding
information for each day beside it.

Example report: cleaning tasks to do
3/1 3/2 3/3 3/4 3/5 3/6
clean bathrooms 1 1
mop floors 2 1
vacuum bedrooms 3
vacuum living 1
wash laundry

My current column report shows this:
3/1
3/2
clean bathrooms 1 clean bathrooms 1
etc...
I want to eliminate the second (and third, and so on) clean bathroom (mop
floors...)row headings.

Thanks.

 

[Michele E]

I forgot something. I also want only the dates that have tasks to be done to
show up. If I am not doing anything on 3/7, then I don't want that date to
report. Also if I'm not washing laundry that week, I don't want wash laundry
to appear. Is that possible?

 

[John W. Vinson]

I want a report which has a lot of information given per each day of the week.
I want to far left column to print only once with the corresponding
information for each day beside it.

Example report: cleaning tasks to do
3/1 3/2 3/3 3/4 3/5 3/6
clean bathrooms 1 1
mop floors 2 1
vacuum bedrooms 3
vacuum living 1
wash laundry

My current column report shows this:
3/1
3/2
clean bathrooms 1 clean bathrooms 1
etc...
I want to eliminate the second (and third, and so on) clean bathroom (mop
floors...)row headings.

Thanks.

Could you perhaps share with us the structure of your table? It's a bit hard
to tell, other than that some sort of Crosstab query would probably be
appropriate.

 

[De Jager]

Could you perhaps share with us the structure of your table? It's a bit
hard
to tell, other than that some sort of Crosstab query would probably be
appropriate.

 

[Michele E]

Here's what I have. Hopefully this makes sense. I have a database with two
tables in it that are linked. Table 1 has all of the production data for our
plant in it. It has the date, shift, shift supervisor, machine number,
operator (on that machine), product being made, total production (number of
rolls made), etc...
Table 2 has the off quality production made with the reason for the off
quality.
So it will say something like 3 (rolls) for dirt (reason for poor quality),
4 for wrong size, 7 for bugs, etc... The ID number on the first form (input
to Table 1) links to the ID number on the second form (input to Table 2).

I want my report to give the number of off quality rolls and the main
reasons (sorted in descending order) for a given time period. Keep in mind,
there are currently 35 reasons for a roll to be off quality.
I'd like it to look something like this...
Total Total Off
Main Reasons
Date Machine No. Operator Rolls Made Quality Rolls for Off
Quality
3/16/10 27 Bill 15 5
3 bugs

2 dirt

3/16/10 28 Tim 10 4
2 wrong size

2 bugs

If it can't do this, then I'd like to just have a summary each day that
shows this:

Date 3/16/10 3/16/10
Machine 27 28
Operator Bill Tim
Rolls Made 15 10
Bugs 3 2
Wrong size 0 2
Dirt 2 0
Total 5 4

Thanks!