Why don't you break the select statement down into its component parts, and google each one? That's what I would have to do to answer your question, and no doubt many others here would have to do as well. For instance, googling "ms access max statement" returns 14.4 MILLION results, amonfg them is this link:
http://www.databasedev.co.uk/access_max_function.html[
^]
EDIT ============
Are you down-voting this because I tried to get you to make some sort of effort of your own, or because I didn't spoon-feed you the precise translation? In either case, it indicates poor social skills on your part.