Need help with query - can I make this row data into column data?

[kellstee]

We have an app that holds lots of records - the record tells the app what report to run at what time.

So, it looks like this:
Report Run Time
-------------------
A 9:15
B 9:35
C 10:45
D 9:16
E 8:12
A 20:15
B 21:15
A 7:00
D 8:00
F 21:00

I need a report that looks like this:

Report Run Time Run Time Run Time
-------------------------------------------
A 7:00 9:15 20:15
B 9:35 21:15

I want one report per row and the times to appear in columns. Some reports get run 5 times a day so the run time would be in 5 different columns. Other reports are only run once, so only the first column should be populated.

Is this possible?

 

[PHV]

Why not follow the Crosstab query wizard ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kellstee]

Thanks, ph. That gets me close. My only problem is that I then have over 100 columns and 100 rows which still makes it difficult to read. Is there a way to get the time in the data field instead of making each time a seperate column?

 

[dhookom]

Use a main report based on only the unique [report] values. Then use a multiple column subreport that displays across then down to display the related [Run Time] 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]

 

[kellstee]

Thank you!