K
Kpakute via AccessMonster.com
My report is based on a query and the query is a left outer join of
category table with products table. In my report, I have a running sum
textbox counting the numbers of the products in a particular category. My
problem is when I have a category without any product, the running sum
textbox still displays 1 based on the =1 control. I want to make this
textbox invisible when there is no product in a category. Best I could get
was to make group headers and footers invisible.
Can anyone help with the code for this?
category table with products table. In my report, I have a running sum
textbox counting the numbers of the products in a particular category. My
problem is when I have a category without any product, the running sum
textbox still displays 1 based on the =1 control. I want to make this
textbox invisible when there is no product in a category. Best I could get
was to make group headers and footers invisible.
Can anyone help with the code for this?