Need Help ?

[Oktavianus]

Set db = CurrentDb
Set qdfReport = db.CreateQueryDef("", _
"PARAMETERS BegDate DateTime, LastDate DateTime; "
& _
"SELECT [tblWO].[no_wo], [tblWO].[masuk_tgl],
[tblDataKendaraan].[no_pol], [tblDataPemilik].
[perusahaan], [tblWO].[no_wo] AS wo " & _
"FROM tblDataPemilik RIGHT JOIN (tblDataKendaraan
RIGHT JOIN tblWO ON [tblDataKendaraan].[nokey_cu]=[tblWO].
[nokey_cu]) ON [tblDataPemilik].[IDCU]=[tblDataKendaraan].
[IDCU]" & _
" WHERE ((([tblWO].[masuk_tgl]) Between [BegDate]
And [LastDate])) " _
& " ORDER BY [tblWO].[masuk_tgl], [tblWO].[no_wo]")

My data 30000 each table
I used this at form on load and my form load Slow take
times 10nd
any body know why ???

Thanks

 

[John Vinson]

I used this at form on load and my form load Slow take
times 10nd

Is there an Index on [tblWO].[masuk_tgl]?