I have a report using a fab ticket for production, using fab ticket number
for the key to tie the report to the sub-reports

my sub-reports are for totals of
stock items
purchased items
work labor cost
each of the above gives me the total in each of its own queries

the labor field is always used, but the other are not.
Therefore I get an error message when the field is null
the report works great when we have info in all sections

I don't know any VBA programing but the things I tried are;
iif(Isnull([file name]),0,[file name])
iif(isnull([file name]),0,format([filename],0))
sum(iif([file name]0, true, false)
nz([file name],0)


--
falvey3