Search results

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...

Hi guys, looks like a friendly forum so I decided to join. I've been an IT person for MANY years but have never specialised in Access - it was always the more "industrial" databases. However, I use Access when helping out with a national moth recording scheme. The software we use to maintain...