I assumed "running total" referred to a text box with the Running Sum set to some value other than None. The number of records in a report will have nothing to do with the setting of this property.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@...> wrote:
>
> The running total is because the project is not through yet. There are only 670 records so far. By next October that should be around 6000.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@> wrote:
> >
> > You haven't suggested why you need to use "running total". Based on that, I would simply try:
> > =Sum(Abs([YesNoFieldName]))/Count(*)
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@> wrote:
> > >
> > > I have a report that totals all items on the BibID field. I need to calculate the percent of itmes that have a specific status - Dis-assembled. These are tallied with a checkbox on the Items form. The formula would be Status/Total=%. i.e. 259/670=38.65%. I got the running total on the BibID column with this expression =Count(*).
> > >
> > > How would I reference that running total so I can use it to calculate the percent of the dis-assembled items status to the total?
> > >
> > > Thanks,
> > > John
> > >
> >
>
Tidak ada komentar:
Posting Komentar