I'm processing moth records and am intereted in the earliest & latest appearnces of each species. I'm getting a problem when formatting the date - it seems to subtract a day. I'm using the following SQL :-
SELECT
Taxa.Taxon,
Records.Date,
Format([Date],"ddmmmyyyy") AS RecordDate...