Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Minnesota, USA, Earth
    Posts
    65

    Unanswered: Querying data in two columns

    Hi,

    I'm hoping that this is easy. It seems like it should be easy, but for some reason, I'm stumped.

    I inherited a database with a table that includes two columns. One column is labled "DateofFailure" and the other is labeled "DateofRepair". There are over 12,000 records in this table and there are a number of records where the Date of Repair entered in is BEFORE the Date of Failure that is entered in.

    Now, I know that we're not conducting experiments in Clairvoyance, so I know that it's impossible to repair something that hasn't failed yet. So, how can I filter or construct a query that will tell me which records have a Date of Repair that is earlier than a Date of Failure? So that I can clean this database up!

    Thanks!
    -Mike

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Have you tried a where statement in your query? Such as:
    Where [Date of Repair] < [Date of Failure]

Posting Permissions

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