NL(Rows) does not return duplicate values

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? 


Please sign in to leave a comment.