Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: Access 2007 Joins Problem with Dates

    I am trying to finalize a query and running into issues. I have two tables
    the first one has dates with times (General Date Format) the second has various date fields that can either have date or dates or times. Seems that when I join it only recoginizes the ones with format of m-d-yyyy and not the ones with date/time. how can I fix this problem. Help would be greatly appreciated. Have been struggling with this for the past 3 days.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Since 1/1/2010 12:00am is different to 1/1/2010 9:47am, the only way you can do it is to remove the time component.

    You can do that by having calculated fields in queries (which INT the date field) and then link the queries by that calculated field.

    Note that the performance of this will be quite poor.

    There also may be a normalisation error for you to be wanting to link such data together.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts