L
Lorddy
Guest
I work on a report with dates. There are 337 personnel on the report with 3 fields. In some, but not all of the fields are dates. What I have managed to do so far is obtain a total in each field of dates gainst people. This I have done by a calculation in a text box in the Form Footer. The calculation is as follows:
=Count([BPFA 1])
(The BPFA 1 is the name of this particular field.)
It comes up with the correct total. I have named this text box "Total".
I then created another text box, again in the footer of the form and entered the following calculation:
=Sum(100/[BPFA 1])*Total
This comes up with the answer of 37.305 when it should be 34.71. I cannot get it to work out the % correctly - is there a simpler way?
Also, when I try and do a normal total of the column it comes up with some ridiculous figure - something like 498376 - when it should be 337 (the number of personnel on the Report. The calculation that I use for that is:
=Sum([BPFA 1])
I would be very grateful for any help. Incidentialy, my EMail address is Lorddy545@aol.com
Thanks - Tony
=Count([BPFA 1])
(The BPFA 1 is the name of this particular field.)
It comes up with the correct total. I have named this text box "Total".
I then created another text box, again in the footer of the form and entered the following calculation:
=Sum(100/[BPFA 1])*Total
This comes up with the answer of 37.305 when it should be 34.71. I cannot get it to work out the % correctly - is there a simpler way?
Also, when I try and do a normal total of the column it comes up with some ridiculous figure - something like 498376 - when it should be 337 (the number of personnel on the Report. The calculation that I use for that is:
=Sum([BPFA 1])
I would be very grateful for any help. Incidentialy, my EMail address is Lorddy545@aol.com
Thanks - Tony