how to report totals

Hello,

Thank you to anyone that will look at this post. I am trying to make a
report that gets the information from one field. The field has a drop down
list with selection for the following: Assmt 1-3, Resolute 1-3, Pending 1-3,
closed 1-3. There is total of 12 in the list.

For the report I need to sort and tally the above information like this:

Cat 1 Cat 2 Cat 3
Total
Assessment 0 2 0
2
(IDxxxx, IDxxxx)

Resolution 0 2 2
4
(IDxxxx, IDxxxx) (IDxxxx,IDxxxx)

Etc.

Is this possible to do with the Query and Report function of Access?
For the other report I can have it sort and show each cat and ID in the
order I want, but would like to know if I can do the tally I showed above.
Thank you.

On Aug 6, 9:52 am, Hell-fire
wrote:
Hello,

Thank you to anyone that will look at this post. I am trying to make a
report that gets the information from one field. The field has a drop down
list with selection for the following: Assmt 1-3, Resolute 1-3, Pending 1-3,
closed 1-3. There is total of 12 in the list.

For the report I need to sort and tally the above information like this:

Cat 1 Cat 2 Cat 3
Total
Assessment 0 2 0
2
(IDxxxx, IDxxxx)

Resolution 0 2 2
4
(IDxxxx, IDxxxx) (IDxxxx,IDxxxx)

Etc.

Is this possible to do with the Query and Report function of Access?
For the other report I can have it sort and show each cat and ID in the
order I want, but would like to know if I can do the tally I showed above.
Thank you.

I think u need a report with crosstab query.
HTH
Luan.

Hello Luan,

Thank you for looking at my post. I'm very new to Access, so I would
basically have no idea on how to proceed. If you can briefly outline on how
I would proceed, it would be appreciated. Thank you.

"luan" wrote:

On Aug 6, 9:52 am, Hell-fire
wrote:
Hello,

Thank you to anyone that will look at this post. I am trying to make a
report that gets the information from one field. The field has a drop down
list with selection for the following: Assmt 1-3, Resolute 1-3, Pending 1-3,
closed 1-3. There is total of 12 in the list.

For the report I need to sort and tally the above information like this:

Cat 1 Cat 2 Cat 3
Total
Assessment 0 2 0
2
(IDxxxx, IDxxxx)

Resolution 0 2 2
4
(IDxxxx, IDxxxx) (IDxxxx,IDxxxx)

Etc.

Is this possible to do with the Query and Report function of Access?
For the other report I can have it sort and show each cat and ID in the
order I want, but would like to know if I can do the tally I showed above.
Thank you.

I think u need a report with crosstab query.
HTH
Luan.