skwilliams
Registered User.
- Local time
- Yesterday, 22:45
- Joined
- Jan 18, 2002
- Messages
- 516
I have a form (frmCS) and a subform within it (frmUpselling). This subform has a control source of (qryUpselling). The subform displays records from (qryUpselling) based on each employee along with a total at the bottom of the subform. This is an unbound textbox (Text4) in the subform footer with the control source of "=Sum(Nz([Amt],0))". This all works fine unless the query doesn't contain data for that person. The total at the bottom then displays nothing. When there is no data for that person the subform itself doesn't show anything but the control headers and the empty textbox.
Attached are some screenshots.
Any ideas??
Attached are some screenshots.
Any ideas??