Is this possible with a single query?

[Guest]

Hello,

I'm new to Access and unfortunately been tasked to take care of someone
else's DB. The question I have is, I need to make a report that uses 12
fields of data. But the thing is, I need to have the report to categorise
the 12 fields in into 12 categories. If I make 12 different queries to
handle the categories, I don't know if I can combine them into 1 query.

I don't know how to make just one query to be able to make the 12 different
categories for a report. The 12 fields are: Identifier, T Severity, V
severity, Status, Date opened, Date Closed, Description, Findings, T info, C
info, C Action, P Action, and Additional Comments.

The Status determines the category and there are 12 different status. If I
can do this with one query and have the report separate them in the 12
categories, it would be perfect. Thank you for any possible help you can
give me.

 

[Guest]

There is at least one response in the Reports NG where you asked the same
question. Many of us read through multiple news groups so it is rarely
necessary to post to more than a single NG.