Need help for dublicate values

[prma7799]

Hi All,

I have 1 serial number and one 1 order number and we have multiple dealer for wholesale.

My query is when I select 1 serial number I will get two record for dealer and when select order number then will get one dealer record

so I need only one record when I select serial number.

Thanks

Prashant

[its_anandrjs]

Hi,

Use Distinct to get Single records

Ex:- Count(Distinct [Order No])

Regards

Anand

[prma7799]

Sir,

I want only one record when I select serial number and I used Count(Distinct [Order No]) this..

but not yet come..

[Yousef_Amarneh]

can you share an example with data