|
| 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
August 6th, 2007, 03:32 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Multiple level counts
You folks are always so helpful, I'm hoping you can assist with this.
I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide. 
|
|
#2
August 6th, 2007, 03:46 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
That is correct.
-- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
|
#3
August 6th, 2007, 04:20 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
I'm sorry - I don't understand.
"Klatuu" wrote: That is correct. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
|
#4
August 6th, 2007, 04:24 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
Sorry, I don't know what happened, but I did not intentionly reply to your
question, but if I understand your question, then it should just be a matter of using the Count function in the Disttrict footer like you do in the Dealer footer. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I'm sorry - I don't understand. "Klatuu" wrote: That is correct. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
|
#5
August 6th, 2007, 05:22 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
I tried that, but it just comes up with a count of 1 for each district.
"Klatuu" wrote: Sorry, I don't know what happened, but I did not intentionly reply to your question, but if I understand your question, then it should just be a matter of using the Count function in the Disttrict footer like you do in the Dealer footer. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I'm sorry - I don't understand. "Klatuu" wrote: That is correct. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
|
#6
August 6th, 2007, 07:20 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
Is your sorting and grouping Dealer first then district or the other way
around? Are there any other groups defined? -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I tried that, but it just comes up with a count of 1 for each district. "Klatuu" wrote: Sorry, I don't know what happened, but I did not intentionly reply to your question, but if I understand your question, then it should just be a matter of using the Count function in the Disttrict footer like you do in the Dealer footer. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I'm sorry - I don't understand. "Klatuu" wrote: That is correct. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
|
#7
August 6th, 2007, 09:38 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
Grouping goes District first, then Dealer. There are no other groups defined.
"Klatuu" wrote: Is your sorting and grouping Dealer first then district or the other way around? Are there any other groups defined? -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I tried that, but it just comes up with a count of 1 for each district. "Klatuu" wrote: Sorry, I don't know what happened, but I did not intentionly reply to your question, but if I understand your question, then it should just be a matter of using the Count function in the Disttrict footer like you do in the Dealer footer. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I'm sorry - I don't understand. "Klatuu" wrote: That is correct. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
|
#8
August 7th, 2007, 02:56 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple level counts
If you are counting in the District footer, then a count of one would be
correct. To count the districts, do the count in the report footer. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: Grouping goes District first, then Dealer. There are no other groups defined. "Klatuu" wrote: Is your sorting and grouping Dealer first then district or the other way around? Are there any other groups defined? -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I tried that, but it just comes up with a count of 1 for each district. "Klatuu" wrote: Sorry, I don't know what happened, but I did not intentionly reply to your question, but if I understand your question, then it should just be a matter of using the Count function in the Disttrict footer like you do in the Dealer footer. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: I'm sorry - I don't understand. "Klatuu" wrote: That is correct. -- Dave Hargis, Microsoft Access MVP "Rudolphia" wrote: You folks are always so helpful, I'm hoping you can assist with this. I'm creating a report with a couple of grouping levels to count transactions and calculate percentage of the Area by district and dealer. I successfully created the count by dealer in the Dealer footer, but I can't figure out how to count the records in the District footer. Ultimately, I'll need to count all records in the report footer and create a Percentage of Area calculation for both the Dealer and District footers. I'm not sure how to write the expression that will calculate each dealer/district's trasaction total as a percentage of the total report count. I appreciate any help you can provide.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
