Hi I am trying to return rows which has a lot of duplicate values. But for some reason Jet is getting rid of the duplicate values and showing me just the unique values. I have tried to add more NL(Rows) function on other rows so I get more unique values to return but i can go only so far. does anyone have a solution?
Date
Votes
2 comments
-
Harry Lewis You could use the NL(Rows) to return a record key and then use the NF() function to show the specific fields you want.
e.g.,
=NL("Rows","my_table",,"start date","1/1/18")Since the function does not list a specific field (notice that parameter is blank- the double commas), it would return all records from my_table with a start date during this year.
-
Sandeep Kuntam Thank you Harry, Well i am sorry i forgot to update the comment yesterday. That is exactly what i ended up doing to achieve the results.
Please sign in to leave a comment.