report without duplicated one column value (1 Viewer)

[mo7kenawy]

if I have 1 table this table with 6 column

(Name - number1 - number2 - number3 - number4 - number5)

and column (name and number1) can be duplicated

and I need a query to show all data but hide duplicated for number1 show only one value for duplicated value in number1

i'm sorry for my English

 

[theDBguy]

Hi. It might be better if you can demonstrate what you mean by using sample data. For example, create an Excel sheet and put the raw data and the desired output and either post the file or a screenshot.

 

[mo7kenawy]

its example, I need hide one from 2 value in column (number1)

 

[theDBguy]

its example, I need hide one from 2 value in column (number1)

Does it matter which one you hide? Are you saying rather than the query showing three (3) rows, you only want it to show two (2) rows instead?

 

[mo7kenawy]

Does it matter which one you hide? Are you saying rather than the query showing three (3) rows, you only want it to show two (2) rows instead?

Yes

 

[theDBguy]

Yes

Yes, it matters which one to hide? Or, yes, you only want two rows to show up? If the first one, which one would you like to hide?

 

[mo7kenawy]

i need if i have 1000 row with same value in number1 show only one

 

[theDBguy]

i need if i have 1000 row with same value in number1 show only one

Hi. Let me repeat/clarify my question. Your current sample data shows the following data.

I understand you only want to see one "1" for Number1. However, each "1" in Number1 has a different value for Number2 and Number3. So, my question is, how do we determine which row for "1" do you want to see? Does it matter? Do we ignore the one with "100" in Number2 or do we hide the one with "154" instead? Same goes for the Number3 column, which one to hide, "100" or "20?"
Does that make sense?

 

[theDBguy]

i need if i have 1000 row with same value in number1 show only one

Here's one way to do it. Open "Query1." Hope that helps...

 

[arnelgp]

another approach.

 

[mo7kenawy]

another approach.

Thank U

Here's one way to do it. Open "Query1." Hope that helps...

Thank U

its good for me but i need update


if I have a table I attached it and I need to make query

if NameCode Duplicated sum Number1 and 2 and 3 and query show all other table but in number1 and 2 and 3 show the result