Morning,
I receive monthly data from a third party, once received it is exported from excel into my access database with an automatic date (the date the data is entered into the table). I've entered criteria '[EnterDate]' so that when the query is run a box comes up and asks for a date. I'd like to enter the criteria so it provides the possible dates (rather than having to enter it in) with the latest date on top.
Thanks,
Simon