I am making a Database for Payroll, I have a Report SalarySheet and I need a Column Say Bonus, but The Column Bonus will have values in only Once in a Year. i.e. it will have value in only for one Months Salary Sheet Rest 11 months it will remain empty and unnecessarily occupy space.
I need a Column which will auto hide with his Lable (Tile of the Field) when it has Zero in all the month and will show only when it has some value in any record
My Report is Tabular Format
Grouped
and based on Query
I ma using MS Access 2007
Try to give solutions in Expression Builder, codes are so complicated, even if not possible Code will done
Please give me some hint or solutions
Thanks in Advance as I know all your guys are experts of Access