Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How can I determine distinct records in an Access?

Discussion in 'Information Technology' started by super_nay30, Jul 28, 2006.

  1. super_nay30

    super_nay30
    Expand Collapse
    Guest

    I am using Access 2003 and I have just performed an 'append query' to have
    data from two tables consolidated into one. The trouble I have is that the
    field I used as a link can often appear twice in the second table and
    therefore pulls back two or more records. The two or more records aren't
    identical however, they will usually have at least one field that is
    different.

    For example, if I have CustomerA who has two orders, both orders are
    retrieved into the append table however I only want to see the latest order
    placed not the earlier orders. What is the best way of only having the latest
    match appear?

    Many Thanks
    Renee
     
  2. Loading...

    Similar Threads Forum Date
    Nature Scientists Determine Earth has 8.7 Million Species Breaking News Aug 26, 2011
    Sikh Preacher Determined to Keep Speaking Sikh Sikhi Sikhism Apr 6, 2010
    Sikh News Joe Biden runs into a determined young Sikh Girl Breaking News May 23, 2009
    Sikh News Punjab govt determined to eliminate child labour: Minister (Outlook India) Breaking News Nov 14, 2007
    Free/ Pre-determined Human Will? Interfaith Dialogues Oct 31, 2006

  3. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    use an aggregate query to get the max date for each, then
    join back to the table to select only the records with the
    max date

    (david)

    "super_nay30" <super_nay30@discussions.microsoft.com> wrote in message
    news:DDDC73AC-8509-4E6A-8F46-0896FFCE86A1@microsoft.com...
    >I am using Access 2003 and I have just performed an 'append query' to have
    > data from two tables consolidated into one. The trouble I have is that the
    > field I used as a link can often appear twice in the second table and
    > therefore pulls back two or more records. The two or more records aren't
    > identical however, they will usually have at least one field that is
    > different.
    >
    > For example, if I have CustomerA who has two orders, both orders are
    > retrieved into the append table however I only want to see the latest
    > order
    > placed not the earlier orders. What is the best way of only having the
    > latest
    > match appear?
    >
    > Many Thanks
    > Renee
     

Share This Page