Is there a way I can multiply by the number of records on the report?
Printable View
Is there a way I can multiply by the number of records on the report?
Send Ur table Format
huh?
Can you give some more detail as to what you're trying to do?Quote:
Originally Posted by Besoup
Ok I have a report that displays a bunch of employee records and what they contribute to some weekly office pool. Everyone puts in $.50 and I need to display that in the details with everyone employee name. Then I need to have a total of the contributions on the footer...
The easiest way I can think of would be to group by employee and have a group total in the group footer.Quote:
Originally Posted by Besoup
HTH
Quote:
Originally Posted by King_George
I would do that if I could get a sum on my formula field... I tried making a fomula field with the value .50 and for some reason when I go to make a sum it won't show up in the list of fields....
there is one shortcut for this .
put a text field with value .50 in front of each employee
then at the footer put a formula filed in which u multiply the recordnumber field ( u can get this field from insert -> special fields ) with the .50 , and by this u can get the correct value
thanks
thnx