Query the last 3 records entered

[jyellis]

TableMaster

Fields
ID, FName, LName, Region



TableMileage

Fields
ID, Vehicle, Mileage

One to many relationship setup with tables never being sorted.


Results returned: the last 3 milege numbers entered for each ID # (person)

Results returned:

By Region, then by LName, then the last 3 mileage records entered.


So each ID record will have up to 3 records return in query. (If an ID only has 2 then return the 2 records.)

Thank you.

[orange]

What have you tried?
See Top N at this site:
http://allenbrowne.com/subquery-01.html