PDA

View Full Version : Cross Tabs Query in Access Report


bbigelow
06-24-2008, 04:00 PM
I am using a Crosstabs Query for finished and unfinished totals in an Access Report. When there are no more unfinished items to report I get an error on the report and have to remove the unfinished box. I have tryed to use iif() statements such as: =iif(Check_CrosstabsUnfinished.106,Check_Crosstabs Unfinished.106,Null)

Am I missing something? I need for the report to run automatically without my having to delete text boxes everyday.

Any help at all

Thanks you guys are great.