Field propagation

[Ron Stewart]

How do I keep an empty field from propagating to my form.
I only want the fields with data in them to make it to the
eventual invoice

 

[Michel Walsh]

Hi,


Using a criteria, in a query or as a filter like: WHERE FieldName Not Is
Null

or
WHERE Not ( FieldName Is Null)

Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Hi,


Note that if the field is implied in a summation, with other fields of
the SAME record, use NZ around it:

Nz(f1, 0) + Nz(f2, 0) + Nz(f3, 0)


as example.



Hoping it may help,
Vanderghast, Access MVP