• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

report without duplicated one column value (1 Viewer)

mo7kenawy

New member
Local time
Today, 11:47
Joined
Aug 27, 2020
Messages
12
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

I’m here to help
Staff member
Local time
Today, 02:47
Joined
Oct 29, 2018
Messages
12,440
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

New member
Local time
Today, 11:47
Joined
Aug 27, 2020
Messages
12
its example, I need hide one from 2 value in column (number1)
 

Attachments

  • Database51.accdb
    400 KB · Views: 6

theDBguy

I’m here to help
Staff member
Local time
Today, 02:47
Joined
Oct 29, 2018
Messages
12,440
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

New member
Local time
Today, 11:47
Joined
Aug 27, 2020
Messages
12
i need if i have 1000 row with same value in number1 show only one
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:47
Joined
Oct 29, 2018
Messages
12,440
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.
1599241796763.png

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’m here to help
Staff member
Local time
Today, 02:47
Joined
Oct 29, 2018
Messages
12,440
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...
 

Attachments

  • Database51.zip
    18.5 KB · Views: 6

arnelgp

error reading drive A:
Local time
Today, 17:47
Joined
May 7, 2009
Messages
10,542
another approach.
 

Attachments

  • Database51X.zip
    18.7 KB · Views: 6

mo7kenawy

New member
Local time
Today, 11:47
Joined
Aug 27, 2020
Messages
12
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
 

Attachments

  • sum.png
    sum.png
    5.4 KB · Views: 5

Users who are viewing this thread

Top Bottom