make query fields not display if null data

[rivereridanus]

Hi,



I have a query which will select 20some fields, but they will not all contain data. Is there a way I can stipulate in my query that the field should not appear if the data is null?

For example, if ORDER.object4 IS NULL, (do not display??). I have no idea if this is even possible!

Thanks

[ajetrumpet]

no there isn't. the only you can do it is through creating a querydef in code.