Dear Access wizards,
Currently I'm using Access to store weekly data of our market.
Every week I receive a flatfile which I integrate in Access.
As a timekey I'm using a CYWEEK (example: 201615).
Now the thing is, when I make a query, I want to be able to see the latest week (highest value)...