deleting specified records in Acess database

[JillB]

I am trying to delete records numbered say, 3000 to 4000 in Access database. I can do a delete Query, but do not know how to specify the record numbers in the criteria.

can anyone please advise.

my regards,
Jill ( Access newby)

[hspc]

Can you post some information about the structure of the table?
the query can be like:
Delete tablename where ID between X and Y

[KrisSimonis]

Quite easy actually.. a DELETE statement is pretty much like a SELECT statement. To specify the proper records, you use a WHERE condition. Every record that evaluates the where condition as TRUE will be deleted.