Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New Coder
    Join Date
    Apr 2008
    Thanked 0 Times in 0 Posts

    duplicate records

    Hi the below query returns the records i want but I also need it to return distinct values based upon one field.

    I am using MSAccess

    SELECT videovault.Path, ColourType.ColourPath, videovault.EffectType
    FROM ColourType
    INNER JOIN VideoVault ON ColourType.ColourName = VideoVault.EffectType
    WHERE videovault.productCode = 'J72673'
    There is a field called EffectType that needs to be distinct no matter what.

    I have tried the distinct clause and group by function but it still returns the records with the field EffectType having duplicate entries.

    Any ideas on what to do please?

    Last edited by robert475; 03-16-2010 at 06:38 PM.


Posting Permissions

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