Exclude Unique Value Field From DISTINCT

[vdanelia]

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]

Could you elaborate? It can either be DISTINCT or non-DISTINCT. Not a mixture of both.

 

[vdanelia]

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]

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.

 

[vdanelia]

Could you elaborate? It can either be DISTINCT or non-DISTINCT. Not a mixture of both.

Thanks a lot You explained Everything with it!

 

[vbaInet]

No problemo!