I have been trying to write a report for a purchase order database which totals the purchase order value. I can get the function to work in part using: [function_name] + [field_name].
This works for most purchase orders, however some purchase orders have a null value against an item cost. This is because users have added an item record to expand on the service they require rather than keeping it all in one field.
To accommodate this I amended the function to: [function_name] + IF([field_name]=NULL;0;[field_name]), but this gives me a completely blank total field. where purchase orders contain null item values.
I have also tried IF(ISBLANK… and get exactly the same problem.
Can anyone help?
Thanks