Returning NULL fields in a report with a query.

[Eltoque]

I have a report that runs off a form query. The form query is working fine as well as all the componenets but when I run a report to return all record, it will not return records that have blank fields. How do I set up the query or report to make no designation between full records and records with no entries filled in (Null / Zero length) ?

Please help!!!
Thank you.

 

[scking]

In the query designer try:

Enter in the Field area for a text row,
NewValue:nz(OldValue,"&quot

Enter in the Field area for a numeric row,
NewValue:nz(OldValue,0)

Merely replace 'NewValue' with whatever you want the query column to be labelled and 'OldValue' with the name of the field from the source table.

Steve King
Growth follows a healthy professional curiosity