delete record

[florin]

How can I delete only one record in a table?
I don't need a condition for record that I want delete,
I want delete an record witch an pozition in a table.

Ex

Field1 Field2 Field3
c1 m1 100
c15 m7 200
c1 m1 100
c12 m2 50
c15 m7 200

I want delete only the second record.

 

[Douglas J. Steele]

Create a query that selects only the row you want to delete.

Change the query into a delete query (assuming you're using Access 2003 or
older, you can do thise in the Query menu when you've got the query open in
Design view)

 

[florin]

How can I create a query that select only an record (I can't put a
condition)?
The record is selected in an form.

 

[Douglas J. Steele]

You must have a condition. There's no other way.

Rereading your original post, the concept of "position in a table" is
meaningless. You cannot make any assumptions about the position of rows in
your table. Access will put the data wherever it thinks is best. The only
way you can be sure of the order of the data is to use a query with an
appropriate ORDER BY clause.