Below is a report from VS 2005 to show all my reports for customers but i
only want to show the last visit for each customer regardless of which owner
visited last, at the minute it shows evry last visit per owner...
SELECT DISTINCT new_accountidname, new_branch, MAX(new_end) AS Expr1,
WHERE (new_end < GETDATE())
GROUP BY new_accountidname, new_branch, owneridname
any ideas how i can filter this?