Delete blank fields

  • Thread starter Thread starter Rosina McLaughlin
  • Start date Start date
R

Rosina McLaughlin

How do I delete blank fields within a field

example this is a column.

Field 20

empty field
empty field
3633701
3633702

How do I delete these empty feilds or cells

Thank you,

Rosina McLaughlin
 
How do I delete blank fields within a field

example this is a column.

Field 20

empty field
empty field
3633701
3633702

How do I delete these empty feilds or cells
Click to expand...

You're thinking spreadsheet. ACCESS IS NOT A SPREADSHEET. It doesn't
have "cells"; it has Records which consist of Fields.

You can delete a record using a Delete query; a criterion of

IS NULL

on Field20 will cause all records where Field20 is empty to be
permanently and irrevokably deleted (no matter what's in the other
fields). Is this what you want?
 
Back
Top