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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Fields in a query 4
Query criteria in a memo field 1
Find fields with only numbers in Text formatted column 2
If statement that returns all entries or one 2
Blank field in form 1
Showing Blank fields in Query 2
Sum of Amount 3

Back
Top