Calculate a percentage by records that contain the same data

[Guest]

i have a query set up through a report to list a clients deliverys it also
lists the zone that those delivery locations fall in.

i need access to calculate a percentage of thats clients deliveries to a
particular zone. if anyone could help me out with the best way to do this i
will be very grateful

 

[Guest]

In design view for the form, set up Grouping by Client, then by zone.
Create both a header and foorter for each (you can easily hide them from the
report so no one would see them anyway).

You should then be able to create a field that takes the count of zones
from the zone section and divides it by the count of zones from the client
section :

In the footer area for the zone create a text box : = count([Zone])
In the footer area for the Client create a text box : =count([Client])

In the detail area for the report create a text box: =
([countofzone]/[countofclient])

Follow up if that's not clear or doesn't work for you..


BAC

 

[Guest]

Thanks For your help but i didnt seem to slove my problem, we're on the right
track... i think i better explain what i require

the query asks for the client's name to select from the table.. it displays
all that clients deliveries and the zones they fall into so there all the one
client on the report but they list upto ten zones numbered 1-10 accordingly.

if its easier to figure out i can always use the query to ask for a specific
zone ofcourse but i wanted it to say "here are the deliveries for the client
u asked for to such and such zone" then somewhere to say (maybe in a sub
report) blah percent delivered to zone 1 and so on.

thank you for your quick response hope to hear from u soon
regards
AnnAKeY666

In design view for the form, set up Grouping by Client, then by zone.
Create both a header and foorter for each (you can easily hide them from the
report so no one would see them anyway).

You should then be able to create a field that takes the count of zones
from the zone section and divides it by the count of zones from the client
section :

In the footer area for the zone create a text box : = count([Zone])
In the footer area for the Client create a text box : =count([Client])

In the detail area for the report create a text box: =
([countofzone]/[countofclient])

Follow up if that's not clear or doesn't work for you..


BAC

i have a query set up through a report to list a clients deliverys it also
lists the zone that those delivery locations fall in.

i need access to calculate a percentage of thats clients deliveries to a
particular zone. if anyone could help me out with the best way to do this i
will be very grateful

 

[Guest]

I'm confused...

Using the solution I offered yesterday you're report would look something
like this:

Company Zone Number of Ships Percent of ships
A 1 2 20
2 5 50
3 3 30


B 1 8 80
2 0 0
3 2 20


You could always adda "total" line or put the per-centage numbers into a
sub-form, if you'd like

Is that not what you wanted?

Thanks For your help but i didnt seem to slove my problem, we're on the right
track... i think i better explain what i require

the query asks for the client's name to select from the table.. it displays
all that clients deliveries and the zones they fall into so there all the one
client on the report but they list upto ten zones numbered 1-10 accordingly.

if its easier to figure out i can always use the query to ask for a specific
zone ofcourse but i wanted it to say "here are the deliveries for the client
u asked for to such and such zone" then somewhere to say (maybe in a sub
report) blah percent delivered to zone 1 and so on.

thank you for your quick response hope to hear from u soon
regards
AnnAKeY666

In design view for the form, set up Grouping by Client, then by zone.
Create both a header and foorter for each (you can easily hide them from the
report so no one would see them anyway).

You should then be able to create a field that takes the count of zones
from the zone section and divides it by the count of zones from the client
section :

In the footer area for the zone create a text box : = count([Zone])
In the footer area for the Client create a text box : =count([Client])

In the detail area for the report create a text box: =
([countofzone]/[countofclient])

Follow up if that's not clear or doesn't work for you..


BAC

i have a query set up through a report to list a clients deliverys it also
lists the zone that those delivery locations fall in.

i need access to calculate a percentage of thats clients deliveries to a
particular zone. if anyone could help me out with the best way to do this i
will be very grateful

 

[Guest]

yeh but i dont think that'll work

my report is as follows

(this valu remains the same
as it is client specific)
Client Zone
delivery 1 4
delivery 2 5
delivery 3 10
delivery 4 7
delivery 5 1
ect

then i think it would be best so have a sub report with percentages i.e

zones
1 %
2 %
3 %
4 %
5 %
6 %
7 %
8 %
9 ect
10

hope this clears the air
thanks dude

I'm confused...

Using the solution I offered yesterday you're report would look something
like this:

Company Zone Number of Ships Percent of ships
A 1 2 20
2 5 50
3 3 30


B 1 8 80
2 0 0
3 2 20


You could always adda "total" line or put the per-centage numbers into a
sub-form, if you'd like

Is that not what you wanted?

Thanks For your help but i didnt seem to slove my problem, we're on the right
track... i think i better explain what i require

the query asks for the client's name to select from the table.. it displays
all that clients deliveries and the zones they fall into so there all the one
client on the report but they list upto ten zones numbered 1-10 accordingly.

if its easier to figure out i can always use the query to ask for a specific
zone ofcourse but i wanted it to say "here are the deliveries for the client
u asked for to such and such zone" then somewhere to say (maybe in a sub
report) blah percent delivered to zone 1 and so on.

thank you for your quick response hope to hear from u soon
regards
AnnAKeY666

In design view for the form, set up Grouping by Client, then by zone.
Create both a header and foorter for each (you can easily hide them from the
report so no one would see them anyway).

You should then be able to create a field that takes the count of zones
from the zone section and divides it by the count of zones from the client
section :

In the footer area for the zone create a text box : = count([Zone])
In the footer area for the Client create a text box : =count([Client])

In the detail area for the report create a text box: =
([countofzone]/[countofclient])

Follow up if that's not clear or doesn't work for you..


BAC
:

i have a query set up through a report to list a clients deliverys it also
lists the zone that those delivery locations fall in.

i need access to calculate a percentage of thats clients deliveries to a
particular zone. if anyone could help me out with the best way to do this i
will be very grateful

 

[Guest]

Send me your e-mail address and I'll forward you a sample .mdb and report
form...

remove "_Spammer" from below...


(e-mail address removed)

yeh but i dont think that'll work

my report is as follows

(this valu remains the same
as it is client specific)
Client Zone
delivery 1 4
delivery 2 5
delivery 3 10
delivery 4 7
delivery 5 1
ect

then i think it would be best so have a sub report with percentages i.e

zones
1 %
2 %
3 %
4 %
5 %
6 %
7 %
8 %
9 ect
10

hope this clears the air
thanks dude

I'm confused...

Using the solution I offered yesterday you're report would look something
like this:

Company Zone Number of Ships Percent of ships
A 1 2 20
2 5 50
3 3 30


B 1 8 80
2 0 0
3 2 20


You could always adda "total" line or put the per-centage numbers into a
sub-form, if you'd like

Is that not what you wanted?

Thanks For your help but i didnt seem to slove my problem, we're on the right
track... i think i better explain what i require

the query asks for the client's name to select from the table.. it displays
all that clients deliveries and the zones they fall into so there all the one
client on the report but they list upto ten zones numbered 1-10 accordingly.

if its easier to figure out i can always use the query to ask for a specific
zone ofcourse but i wanted it to say "here are the deliveries for the client
u asked for to such and such zone" then somewhere to say (maybe in a sub
report) blah percent delivered to zone 1 and so on.

thank you for your quick response hope to hear from u soon
regards
AnnAKeY666

:

In design view for the form, set up Grouping by Client, then by zone.
Create both a header and foorter for each (you can easily hide them from the
report so no one would see them anyway).

You should then be able to create a field that takes the count of zones
from the zone section and divides it by the count of zones from the client
section :

In the footer area for the zone create a text box : = count([Zone])
In the footer area for the Client create a text box : =count([Client])

In the detail area for the report create a text box: =
([countofzone]/[countofclient])

Follow up if that's not clear or doesn't work for you..


BAC
:

i have a query set up through a report to list a clients deliverys it also
lists the zone that those delivery locations fall in.

i need access to calculate a percentage of thats clients deliveries to a
particular zone. if anyone could help me out with the best way to do this i
will be very grateful