Hello,

I posted this also in Queries, but since this affects both Queries and
Reports, I thought it best to post it here as well.

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.

Also if its possible to have the report to be able to sort the Status field
into the 12 categories would be useful as well. I'm not sure if this is
possible but would like to know if it is or if I need to try something else.
Thank you for any possible help you can give me.

Other than your table structure seeming un-normalized, I'm not sure what you
are asking for. I don't know why you need to create multiple similar queries
when you report can simply group on the status field.
--
Duane Hookom
Microsoft Access MVP


"Hell-fire" wrote:

> Hello,
>
> I posted this also in Queries, but since this affects both Queries and
> Reports, I thought it best to post it here as well.
>
> 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.
>
> Also if its possible to have the report to be able to sort the Status field
> into the 12 categories would be useful as well. I'm not sure if this is
> possible but would like to know if it is or if I need to try something else.
> Thank you for any possible help you can give me.

Hi Duane,

Thank you for responding to my post. I'm still new to Access, so not really
which way to proceed. I know a little about the sorting and grouping window.
Also with this report, its has two other types of information to be
included. One is like a totals table, the the 12 categories, and lastly a
detail. The person that assigned this project to me, prefers everything to
be in one report instead of 3. Would it be better to use subreports for each
when making this report? Thank you.

"Duane Hookom" wrote:

> Other than your table structure seeming un-normalized, I'm not sure what you
> are asking for. I don't know why you need to create multiple similar queries
> when you report can simply group on the status field.
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Hell-fire" wrote:
>
> > Hello,
> >
> > I posted this also in Queries, but since this affects both Queries and
> > Reports, I thought it best to post it here as well.
> >
> > 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.
> >
> > Also if its possible to have the report to be able to sort the Status field
> > into the 12 categories would be useful as well. I'm not sure if this is
> > possible but would like to know if it is or if I need to try something else.
> > Thank you for any possible help you can give me.