Dates

[DebB-Lost in Oregon :)]

I am trying to write a query that will return the last four dates a customer
has visited me. The database I am working with does not assign trip numbers
so all I have to work with are the actual dates of the visits. How can I get
it to return the last four trips for all of my customers when each person's
actual visit dates will be unique? My mind kept going back to using a date
range, but because everyones last four visits are different, that won't work.
(For example: Fred visits me four times in one week while Wilma visits me
four times in one month. So if I were to query the last month, I would get
Wilma's last four visits, but it would return 16 visits for Fred instead of
the four I am going after.)

 

[Allen Browne]

See:
Subquery basics: TOP n records per group
at:
http://allenbrowne.com/subquery-01.html#TopN

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"DebB-Lost in Oregon " <DebB-Lost in Oregon @discussions.microsoft.com>
wrote in message
news:[email protected]...