Exclude Unique Value Field From DISTINCT (1 Viewer)

vdanelia

Registered User.
Local time
Today, 06:49
Joined
Jan 29, 2011
Messages
215
Hello Mates Need your Help!

I have report which is based On a QRY "QRYName" I use distinct, for example:

SELECT DISTINCT QUERYDATA.Product, QUERYDATA.Brand, QUERYDATA.Model,
FROM QUERYDATA

I want to add a bar code but how to exclude it from distinct?
Thank you in Advanced
 

vbaInet

AWF VIP
Local time
Today, 13:49
Joined
Jan 22, 2010
Messages
26,374
Could you elaborate? It can either be DISTINCT or non-DISTINCT. Not a mixture of both.
 

vdanelia

Registered User.
Local time
Today, 06:49
Joined
Jan 29, 2011
Messages
215
Hello vbaInet
The field "Barcode" Is Non-Distinct... My one Report is based on that Query, on the report I use the Text Box "Barcode" How to solve this, Other fields are to be DISTINCT Except one field Barcode
 

vbaInet

AWF VIP
Local time
Today, 13:49
Joined
Jan 22, 2010
Messages
26,374
I still don't follow. If you want the Barcode not to be distinct then it will make the other records to become non distinct too. Maybe you can show me a spreadsheet of what you're trying to do.
 

Users who are viewing this thread

Top Bottom