I try to create SQL from my table but after I run it .. it's very very wasting time to wait for load .. any body know how to solve
my problem for make faster while loading the records by using SQL ?

the statement is :

Dim DBDS as Database
Dim RDS as Recordset

Set DBDS = OpenDatabase(DS.DatabaseName, False, True, DS.Connect)

sqltrap = "Select * from DS where tgl = " & "#" & txtDate.Text & "#" & "Order by pl_no, line, cproc, worker"
Set RDS = DBDS.OpenRecordset(sqltrap)

thanks for any advice

Regards
Winan