Duplicate Function Error

[Sayad]

Why gate entry not show Duplicate.

ALL these statements are true:
....1: This statement is false:
........ALL these statements are true:
............1: (The value of column 'GATE ENTRY NO') is greater than (1144990)
............2: (The value of column 'GATE ENTRY NO') is less than (1000000)
....2: This statement is false:
........((The list of values of column 'GATE ENTRY NO'
............from rows of table 'CAMPUS SCAN SHEET'
............where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
............The value of column 'GATE ENTRY NO')) is empty

[Marc_Dillon]

Did you try kicking it?

[Joseph_Seddik]

@Marc_Dillon 🤣 H.I.L.A.R.I.O.U.S 😂

[Sayad]

What happened? Why you laughing.

[Joseph_Seddik]

1. What is the name of the column where you are using this expression?

[Joseph_Seddik]

Your expression is meaningless, and it will always evaluate to the same thing (false) no matter what, so it is also useless. 

• How can x be greater than 10 and smaller than 5 at the same time? 
• You are collecting a list of keys matching a certain value, and because it is a key, there can only be one key matching this value, so you end up with a single-value list, then you remove this value from the list. 

I'm pretty sure what I've written above is "not helpful" to you, and no one actually would be able to help you because you keep ignoring what several members of this community, including myself, have been telling you about how to write meaningful questions and make it easier for the community members to help you. 

Anyway, let's work together on this, we'll make it an exercise, so that at the end you get the solution for your problem.

To help me provide a solution to your problem, let's play a game, I will ask you simple questions and you will provide simple answers. Please reply to the following:

1. What is the name of the column where you are using this expression?
2. What is the name of the column field where you have put this expression?
3. What is the name of the table where this column exists?
   
4. What are the other columns in this table? Please provide a screenshot. 
   
5. What do you want to do? What is the expected outcome from this expression?
6. Does what you want to do involve another table? In this case please provide a screenshot of the columns in that table. 

Awaiting your answers @Sayad. Thanks.