code to delete a record

  • Thread starter Thread starter BIG-DB
  • Start date Start date
B

BIG-DB

Hi.
I have a table being created in MS Access from a query.
The table returns all the data I want in my query based
on the criteria I set. Occasionaly one cell/field in the
table is blank, (Beacuse the original table has a blank
field). Does anyone have some simple code I can run on
the 'Maketable' in the background that will delete the
row or record that has 'nothing in flield 2.

example here
Field 1 field2 field 3
2/5/04 66% 25%
2/5/04 76% 18%
2/5/04 16%
2/5/04 33% 10%

record 3 is the one I want to delete because field 2 is
blank.
Any help would be appreciated.
David
 
David

If you create a query that identifies the row with a Null in field2 (are you
certain it isn't a zero-length string?), you are cleaning up after the fact.

If you are adding rows to the table to start with, why not exclude rows
where field2 is Null?
 
Back
Top