Send me your e-mail address and I'll forward you a sample .mdb and report
form...
remove "_Spammer" from below...
(E-Mail Removed)
"AnnAKeY666" wrote:
> 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
> "BAC" wrote:
>
> > 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?
> >
> >
> >
> > "AnnAKeY666" wrote:
> >
> > > 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
> > >
> > > "BAC" wrote:
> > >
> > > > 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
> > > > "AnnAKey666" wrote:
> > > >
> > > > > 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
Similar Threads
