Hello, How can I write a query to delete first row in the table? Thanks,
D Douglas J Steele Oct 12, 2005 #2 Realistically, you shouldn't think in terms of "first row": data in tables does not have a guaranteed order. To delete a specific row, you should use a Delete query, specifying the primary key for the record you want to delete.
Realistically, you shouldn't think in terms of "first row": data in tables does not have a guaranteed order. To delete a specific row, you should use a Delete query, specifying the primary key for the record you want to delete.
O Ofer Oct 12, 2005 #3 Use this DELETE TableName.* FROM TableName WHERE TableName.FieldName=DMin("FieldName","TableName") FieldName = The name of the field that indicate the which one is the forst row The Min will take the first one If you want the last record change it to max
Use this DELETE TableName.* FROM TableName WHERE TableName.FieldName=DMin("FieldName","TableName") FieldName = The name of the field that indicate the which one is the forst row The Min will take the first one If you want the last record change it to max
