Recent content by MikeCouling

  1. M

    Problems using Date formatting.

    Entertaining stuff! Nothing in there about why Access uses Dec 30 1899. I've always had the impression that the Excel & the Access teams didn't get on but to disagree on that for no better reason would seem a bit extreme.
  2. M

    Problems using Date formatting.

    Glad I wasn't being a total wally DBguy. Dates are always a minefield whatever the platform. I got to find out about the Immediate window as well!!
  3. M

    Problems using Date formatting.

    That's what I get for assuming Access Day 1 was a Jan 1st !! Thanks to Minty for the correct code - does just what I want and has cleared up my misunderstanding of Format - as has CJ's post. Thanks Doc_Man for the link explaining Day 0 was a Dec 30th - I expect there is a good reason for this...
  4. M

    Mike's joined

    On Google Minty. I was looking for the answer to the question I posted in the Queries thread.
  5. M

    Problems using Date formatting.

    Hi Minty, thanks for the reply. I want to find the earliest and latest dates within each year that the moths have ever appeared. So is the earliest ever March 1st or Feb 28th for example? Similarly for latest. I can then see if records reported this year are exceptional or not. Format just...
  6. M

    Problems using Date formatting.

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

    Mike's joined

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