Record Selection (97)

Topic

New Reply

I want to select from a list of date contacted just the last three records to show on a customer report. The table needs to contain all the dates but only the last three are relevant for the sales person’s information sheet. Ant help would be much appreciated
Allan

Reply | Quote

Replies

I’m sure there are other ways to do this, but I would suggest using a query. Sort the data descending and use the TOP 3. The SQL should read something like: SELECT TOP 3 ContactDate FROM ORDER BY ContactDate DESC;

HTH

Reply | Quote

Thank you .. I must be brain dead today.. often use top three or more but didnt think of changing the sorting to descending order!!!… thanks for your help

Reply | Quote