Creating custom reports

[joym]

I am trying to create reports however i am unable to create it as per my bosses requirement.


Instead can i create this on a form instead somehow???


is there a count function i can similar to the count function of the query.

[Micron]

Looks like you need a pivot table view of your data. See if this helps https://support.office.com/en-us/art...0-0a48c1aa6752

If not, or if you really need a report, a combination of Totals queries may work. Perhaps you could combine Dept and Severity data, then use additional Totals queries for the other groupings, placing them in sub reports that you position side by side. The subs would be likely also be grouped by dept, but dept data doesn't have to appear in the subs.

[HiTechCoach]

I am trying to create reports however i am unable to create it as per my bosses requirement.


Instead can i create this on a form instead somehow???
is there a count function i can similar to the count function of the query.

The way I handle this is with multiple sub reports.

The far left sub report with include the department column and the Fault Severity columns. The next sub report would include just the two columns of the Net. Availability. Continuing with the next three sub reports. Each sub report would include the column headers.