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