Create a query that leaves out blank fields

  • Thread starter Thread starter Kirsty
  • Start date Start date
K

Kirsty

Hi, can someone please tell me how I create a query that
leaves out fields with no data in it.

Thanks heaps.
 
Hi, can someone please tell me how I create a query that
leaves out fields with no data in it.

Thanks heaps.
Click to expand...

Impossible, as stated. Every record of a Query must be "homogenous" -
they all have the same list of fields. You can't have a query result
that has six fields in the first record, five in the next, and seven
in the third.

To exclude a record entirely if the field FieldA is blank use a
criterion on FieldA

IS NOT NULL
 
Back
Top