Reporting in "columns"

[cruzinonline]

I've never had a situation like this and it's either impossible or easy, not sure which.

My boss was submitting a monthly report from Excel. Normally, each row would be a "record" but there are some twists here.

The "row" has data for:
Title - Desc - Jan - Feb - and so on. (Example)

Eng Services - Drawing Errors - 100% - 100% - 100% and so on

another row is:

Eng Services - CR Backlog - 1 - 3 - 6 and so on

We are tracking data for 70 Titles over 12 months. This gives me 70 "rows" and 14 "columns". I also need to format each of the data points to give me a "color" code based on expected criteria.

My hack skills would mean creating a table with 980 rows and capture each piece of data as a discrete record. This would mean I would need to build a form that displays every cell. Pretty much a glorified spread sheet.

I had considered creating 70 rows and then collecting records by "month". The problem I have is the reporting. How do I get my "records" to report in a "column" type format?

The reason for the large number of rows is I need to display each item on a form (with tabbed sections0 by department so the users can simply enter the data for that month. That part I have to keep user simple.

To summarize, can I with my limited skills create a report that will sort my records vertically and create a new "column" for each month?

Title: Desc: Jan Feb Mar Apr May ........
Eng CR's 5 4 5 6 3
Eng At Power 90% 75% 80% 72% 95%

and so on.......

 

[CJ_London]

you use a crosstab query which will pivot 'vertical' data to 'horizontal'

you would use conditional formatting to set the background colours.

Looks like values are a mixture of text and numbers with different number formats so this would need to be addressed by converting all values to text for presentation purposes