Delete blank fields

[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

 

[John Vinson]

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

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?