I have a database that is linked to external SQL Server tables. I am playing around with pass-through queries to try and run queries on the server and return the results to my local machine. I'm told that this is faster for tables with tens of millions of rows. However, I want to be able to *prove* to myself that this is faster than a querying using my local machine. How can I display querying time in MS Access? Or if there exists some other way of seeing which query is faster, I'm all ears.

**My code for the pass-through query:**

```
    queryname = "qrypass_AbstrList_QuickInfo"
    Set qdf = CurrentDb.CreateQueryDef(queryname)
    qdf.Connect = "ODBC;DSN=Syteline;Description=Syteline;UID=userID;Trusted_Connection=Yes;DATABASE=ACW_App;LANGUAGE=us_english;"
    qdf.sql = "SELECT LTRIM(RTRIM(lp.lp_num)) as trim_lp, lot.item, lp.loc, lp.whse, lot.lot, lot.qty_on_hand " _
               & "FROM isw_lp As lp inner join isw_lplot as lot on lp.lp_num = lot.lp_num " _
               & "WHERE " & whereclause & ";"

    qdf.ReturnsRecords = True

    DoCmd.OpenReport "rpt_AbstrList_QuickInfo", acViewReport

```