Hello,

I am trying to run a report. I have 26 detail fields for each customer. I want to run a report that includes just the fields that have numbers in them and customers that just have a field with a number in it. I understand how to limit the report by an "or" criteria for the customer but I don't know how to limit the fields on the report to just ones that have balances.

Do I need to do 26 queries to do this? It seems kind of cumbersome. :eek: I am using Access 2007.

Thank you for your help.

Robin;)

WHERE [somefield] Is Not Null

Sometimes though a field may have a Null string.
This happens if an entry is backspaced away by an operator or set to "" instead of Null by code.
Test for this with

WHERE [somefield] <> ""

Thank you for your response. How do I set up the report (in design layout) so it just shows fields if there is a value in the field?

:D