Hi,
Somewhat weird behaviour in testing values in a resulting query.
I have a table where I need to read through a list of data, and apply a charge for matching occurrences. However, only ONE charge for one set of data. I have applied a DISTINCT function to the query, but as I cannot get a completely unique set, the DISTINCT function does not de-duplicate all of the sets.
I have therefore attempted to look for a value that if it repeats for the one data set, I can choose to skip the function that applies the charge.