Search results

  1. C

    Query to find the MIN value of multiple date fields

    HI, I am trying to write a query that includes up to 6 individual dates from a table (or tables) and I want to find the MIN value of all dates in a record, So for example: The [NextExpiry] would look at the 6 dates and show the MINIMUM of those dates to indicate when the next ‘element’ was...
  2. C

    Conditional Format Issue

    Hi, I have an Access DB that tracks expiry dates. Lots of expiry dates for several hundred employees. I produce reports for Managers so they can see when people are approaching specific expiry dates so they can take action and book courses etc. I had a request from the managers to format the...
  3. C

    Introduction

    Hi, I am a new member of the Forum. I have been using Access for many years in my work but although you learn as you go, there is still so much to learn! I am a Brit living and Working in the Middle East (Abu Dhabi) for an Air Navigation Service Provider. I have already posted one question and...
Back
Top Bottom