Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page