If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
how to report totals
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. |
#3
|
|||
|
|||
how to report totals
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. |
Thread Tools | |
Display Modes | |
|
|