removing blank fields in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to build a table using a old database. the field I want has some data
in them but can also have blanks. I do not wan the fields with blanks how do
I accomplish this.
 
I do not wan the fields with blanks
Just omit that field.

Or do you not want records that have blank fields?
Use criteria of Is Not Null on the field.
 
Les

Lets make sure we're using the same words the same way. If you have an
Access table that has multiple fields (i.e., columns) and multiple records
(i.e., rows), then you could have a record with data in some fields and not
in others... and the next record COULD have data in the fields that were
missing in the previous record.

If you don't want the table to have fields with blanks, but some records
don't have blanks, what are you proposing to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top