Hello to all,
Access 2000
I have 2 fields on my report and I want to know the percentage of both
fields. I tried something like this and it gives me ERROR in the
SalesPercentage textbox,
txtSalesPercentage
controlSource = [totalsales] / [numberofsales]
Example
Dept TotalSales NumberofSales
SalesPercentage
101 231 5
???
Dept TotalSales NumberofSales
SalesPercentage
1092 231 5
???
Dept TotalSales NumberofSales
SalesPercentage
234 231 5
???
thanks for any help.
lenny