Crosstab Query Help

[EBox]

Hello:

I am trying to make a crosstab query (I think) from a Select Query.

The select query has 24 with fields corresponding to each hour of the day ("12A", "1A",..."11P") and DOW (for day of the week).

I would like to sum the value in each of the time fields and have that run vertically for the rows and have the DOW field run horizontally across the columns, so I can breakout the total number of records that correspond to each hour of the day and day of the week.

I'm not very experienced at crosstabs, and would welcome anyone who can help me there.

Thanks,
EBox

 

[SkipVought]

Hi,

The ORDER of the data is gonna bite you. This is how it sorts, horizontally or vertically...
[tt]
10A
10P
11A
11P
12A
12P
1A
1P
2A
2P
[/tt]
Why are you not using REAL DateTime values?

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[EBox]

I do have another field that shows the value of the Hour (i.e. 0,1,2...23), and could also order by this. How would I set it up?

 

[SkipVought]

Crosstab Query Wizard

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[dhookom]

What are your actual table and field names with data types? How about a few sample records and desired display?

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]