The best way to average, by dealer, the time lags between the dealers' recording of sales and CarStar's recording of sales is to populate the query with all the attributes, find the time lag for each sale, and then:\ Embed the Avg function in the difference expression.\ Use two queries, one for the differences for each dealer\ Open the Totals row and select Avg for the lag expression\ Sort the data by dealer and use Avg to find the average lags

The best way to average, by dealer, the time lags between the dealers' recording of sales and CarStar's recording of sales is to populate the query with all the attributes, find the time lag for each sale, and then: 1) Embed the Avg function in the difference expression 2) Use two queries, one for the differences for each dealer 3) Open the Totals row and select Avg for the lag expression 4) Sort the data by dealer and use Avg to find the average lags