Here is my question. I have a repeat reqion that shows the following:
Msc, Month, Negligent, Qty and Extended(price).
The Msc is a text entry like MarDiv. Month is a number representing a month. the Negligent field is yes or no. The Qty is a count of either yes or no entires from the Negligent field. The Extended is also a sum of the cost of the same yes or no entires from the negligent field. Can I add a subtotal for the Qty and Extended below each month? I would appreciate any help. I have tried to use simulated repeat with subqueries with no luck. i would rather us a variable if possible to cut down on sql usage.
Thanx.
Rob