Multiple Headers on Access Crosstab Qry or Report

[tigercrap]

Hi,

I am having a little trouble creating a qry or report with more than one header, but i'm not sure if it is possible. I have a query with the following fields:

Location
Position
PStatus ("open" or "filled" entered)

What i am trying to do is count the number of open and filled records by Location and Position:

LOCATION1 LOCATION2 LOCATION3
Open Filled Open Filled Open Filled
Position1 10 5 6 3 15 10
Position2 2 1 4 0 0 5
Position3
etc

Is this possible?

Thanks

 

[dhookom]

Create a crosstab with Position as the Row Heading, Count(Position) as the Value, and Location & "-" & PStatus as the Column Heading.

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]