How to sort the record? I want to sort this two field name "pemilik.Pemilik1"and "[Prestasi hasil].Plot" field name . I relate three tables using "Plot" field name. My tables name is "[Prestasi hasil]","tanah", and "pemilik"

.Open "SELECT pemilik.Pemilik1,pemilik.Pemilik2,[Prestasi hasil].Plot FROM [Prestasi hasil],pemilik,tanah where [Prestasi hasil].Plot=pemilik.Plot and [Prestasi hasil].Plot=tanah.PLOT"