Field propagation

  • Thread starter Thread starter Ron Stewart
  • Start date Start date
R

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
 
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
 
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
 
Back
Top