View Full Version : how to calculate percentage in report


abieyuwae
11-01-1999, 02:12 PM
I'm trying to calculate percentage in a report.
example:
total hrs: =sum([hrs])
percent: =[total hrs]/[grand total]
grand total:=([hrs])

my total hours is fine...but the percentage gives me a bunch of parameter values i never specified and it doesn't show the percentage, only the total hrs shows.
please could anybody help ...as any suggestion is welcome.
thank you.

KDg
11-03-1999, 09:43 AM
It's usually something to do with the field/text box names. Have you tried renaming them as in txtHours etc It may be that it doesn't know what box/record to read off