Problem with OpenRecordset and SQL Statement

[Runey]

Hi there,

Hope someone can help

I am opening a recordset like this, where strDatabase is an SQL Statement

Set rstDatafile = dbDatafile.OpenRecordset(strDatabase, dbOpenSnapshot)

SQL Statement =[tblName] ORDER [Name]

It opens and everything is seemingly OK. However I then run a loop that deletes records as per a set of criteria. If I run this on the same unaltered table I get different results each time. It's almost like the SQL statement is not ordering it the same each time.

Am I doing something worng or is there another way to open a table order it's contents and modify it?

Thanks for your time

 

[Mile-O]

What is the actual SQL statement? It's a bit easier to write it than us having to guess it.

I then run a loop that deletes records as per a set of criteria.

Why not just use a DELETE Query?

 

[Runey]

Hi, Thanks for repsponding.

Ooops I didn't cut and pastse the SQL statement properly. It's a basic one that goes like this

SELECT * FROM [tblGames] ORDER [tblGames].Name

But I think Pats hit it on the head. The Name field could very well have multiple entries that are the same. Can I order by two fields, say Name and Description? The two together would definately be unique.

Thanks for your time

PS: The criteria is pretty compilcated, I'm not sure if I could do it in a DELETE Query. But I'll have a look.