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
There is a field called EffectType that needs to be distinct no matter what.
SELECT videovault.Path, ColourType.ColourPath, videovault.EffectType
INNER JOIN VideoVault ON ColourType.ColourName = VideoVault.EffectType
WHERE videovault.productCode = 'J72673'
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?