Crushing Rows

[SCFM]

I have a table like this:
Field1 Field2


Alfa 1
Beta 2
(Blank) (Blank)
Delta 4
. .
. .
etc.

I need a Visual Basic way to convert the table like:
Field1 Field2
Alfa 1
Beta 2
Delta 4
. .
. .
etc.

In other words, using VB, I need to delete the blank rows. Thanks

[pbaldy]

If you actually want to delete them, run a delete query with

Is Null

as the criteria on those two fields.

[SCFM]

Thank you, but I'm really interested in a VB script.

[pbaldy]

Ah, you want to use the more difficult and complicated method. You can open a recordset on the table, loop through it, and delete any record where those two fields are empty (or whatever the appropriate criteria are). It will take a lot longer and not be as reliable, but it will use VBA. Look at recordsets (DAO or ADO), loops, and the Delete method.

[NTC]

sheesh - Baldy - what's the point in trying to help these guys !!... wants a "vb script" ...gimme a break.....post at a vb forum then - - this is a db forum and expect sql solutions......if it works it works; and besides an sql statement can be in vb so what's the dif.....