Search results
-
3
Text Box Expression Problem
It looks like we missed one more parenthesis. Try this =IIf(IsNull(DSum("[YTD]","qryIncidentLog-Year-crosstab","[UrgencyID]=3")),0,(DSum("[YTD]","qryIncidentLog-Year-crosstab","[UrgencyID]=3")) -
3
Text Box Expression Problem
Try this =IIf(IsNull(DSum("[YTD]","qryIncidentLog-Year-crosstab","[UrgencyID]=3")),0,(DSum"[YTD]","qryIncidentLog-Year-crosstab","[UrgencyID]=3")) -
3
Hide empty fields on report
I have a report with multiple fields (textboxes and corresponding labels). They are all lined up horizontally one under the other. The form is bound to a table populated through a form. Not all fields will be populated on that form for each record. I would like to set a procedure on the OnOpen...