Results 1 to 2 of 2
  1. #1
    rgwynne is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    1

    Matching Query Dates

    Hey there,



    In my database I am trying to create a query made up of fields from other previously created queries. In these previous queries there are chemical sampling dates and values. Most of the dates match up but some do not, and this causes access to duplicate values where dates do not match.

    Is normalization the answer here? And if so is there a method i can use that does not involve scrolling through thousands of data points to find where dates do not align?

    Thank you for your help

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Can you see why some of the dates do not match up and why?? It may be that you need to format all the dates in the same way - you could do this via an update query.

    Also I would look at where the dates are coming from and make sure that they are always entered in the same format.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Fortnightly Dates
    By san-ron in forum Programming
    Replies: 3
    Last Post: 04-14-2009, 12:19 PM
  2. Display Non Matching Data
    By k1fox in forum Access
    Replies: 1
    Last Post: 04-03-2009, 07:18 PM
  3. Partial Matching based Queries
    By Yatesb in forum Queries
    Replies: 0
    Last Post: 02-23-2009, 01:06 PM
  4. Can Microsoft Access Matching Values?
    By Toniol in forum Access
    Replies: 0
    Last Post: 12-23-2008, 05:35 PM
  5. Matching positive with negative amounts
    By cwert11 in forum Access
    Replies: 1
    Last Post: 09-29-2008, 12:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums