Dynamic Crosstab Report 1

[vich]

I am trying to create a report based on a crosstab query which has columns representing the count of types of types of equipment on a job. Example.
Type A Type B Type C Type D
01/01/07 24 10 1
01/02/07 24 9 0
etc.

My problem is there are actually more than 3 upto possibly 10 currently types of equipment and they may not all be used on a job each day. In fact in many cases not used on a job at all.
So... my question is how do I manage the absence of the data/field in the report. The crosstab query does not create the type if it was not used. I have seen many examples of using dates but am not sure how to figure this out. I am sure I will need to manipulate the report either at format or print but not sure if there is an easier way.
Any suggestions will be greatly appreciated.

 

[dhookom]

You can enter all possible types into the Column Headings property.
Column Headings: "Type A","Type B","Type C","Type D",...


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[vich]

Thanks for replying so quickly.

I presume you are talking about in the query setting Headers? I just stumbled upon that as an approach otherwise the "type x" doesn't exist if there wasn't one used on the job for any date.

Am I on the right track?

 

[dhookom]

Just find the Column Headings property of the crosstab query and enter all the possible values.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[vich]

That's where I ended up. THANKS for the help and quick response.