Days since last sale

[bandmolson]

I have a table of sales personnel that tracks all sales and includes the salesman, item sold and date of sale. I want to display in a query each salesperson and how many days since the last sale was made. I have a number of days since last sale but only want to include the number of days since the most RECENT.

[pbaldy]

Try this pseudo SQL, using your names:

SELECT SalesPerson, Max(SaleDate) AS LastSale, DateDiff("d", Max(SaleDate), Date()) AS DaysSinceLastSale
FROM TableName
GROUP BY SalesPerson