In my program I wrote the next sentences:

Set NewWS = DBEngine.Workspaces(0)
Set NewDB = NewWS.OpenDatabase(MY.MDB)
TempStr = "select * from MyTable"
Set NewDyn = NewDb.OpenRecordset(TempStr)

How can I sort on one or two fields?
How can I filter some information from a field?

I hope you will give an answere.

Greetings,

Ingrid.