Delete Record

[Arnie]

Hi Folks thanks in advance for any help

i need to delete record 4, 7, 10, 20 etc in a table either using VB or a
query they will always be the same records.

Ta

Arnie

 

[Rick Brandt]

Hi Folks thanks in advance for any help

i need to delete record 4, 7, 10, 20 etc in a table either using VB or a
query they will always be the same records.

You are not describing an action that would be done in a proper
database. In a spreadsheet perhaps, but not in a database.

Database activities never depend on the order of records in a table.
They should always relay on something about the data itself. Whether it
is in the first row or hundredth row should not matter.

So, if there is something about the DATA in those rows that you can use
for selection criteria then you can use that in a DELETE query.

Perhaps if you described your data and its purpose a bit someone might be
able to understand what you are trying to accomplish.

 

[Arnie]

Sorry originally the data comes from a spreadsheet D3 to D33 in this
selection there are intentional blanks for the spreadsheet (these are the
ones i need to delete) some non intentional blank cells ie no data this time
may exist so i don't want to delete these. i use transfer spreadsheet into a
temp table which i want to manipulate then import it to the desired table.
The reason i am doing this is i don't know how to select cells D1, 2, 3 , 5
,6, 8 etc using VB and transfer them to the intended table. i just thought
this was an easier option.