Search results

  1. L

    Help finding duplicate of reversed fields

    Hi i've just finished doing all the work i was doing with this database and presented it to my boss. she was really pleased with it. i just wanted to say a big thanks again for your help in the duplicates section. Its really apreciated.
  2. L

    Help finding duplicate of reversed fields

    Hi Yeah thats what i was trying to do. thanks a lot, thats great.
  3. L

    Help finding duplicate of reversed fields

    Hi Thanks here's a example of the data its just in a table called Data. i'm wanting to check for duplicates in entries in App1 DOB and App2 DOB even if App1 DOB and App2 DOB have been reversed. hope this makes sense. ID Date App Out Date App In Name App1 DOB App2 DOB Lender 4968...
  4. L

    Help finding duplicate of reversed fields

    Hi thanks for your replies. yeah i used the query design window to create the sql then i was tring to rewrite it to do what i wanted but i have to admit i'm far from great at sql. with regard to the structure issues. i know there is a problem. Basically what has happened is we have an old...
  5. L

    Help finding duplicate of reversed fields

    Hi This is my first post and i searched to try and find an answer on the forums but can't seem to find one so thought i'd ask to see if anyone is able to help. Sorry if this has been answered before and i've been a bit thick not been able to find it. anyway here's my question... I have 2...
Back
Top Bottom