Recent content by sparkanother

Thanks a lot for the effort Brian, i have finally figured it out. There were a lot of empty cells in the text column, they were mixing up the result. This is the working one: AND (Duplicates_Rule1.Check Is Null)) and (Duplicates_Rule1.BSAK_Text Is Null or Duplicates_Rule1.BSAK_Text <> "FREIGHT")

First of all thanks for the help! Yep, the brackets were weird. I have amended them the way you suggested, but it's all the same. The strange thing is that if i change the 'not equal' sign to equal, it gives me 108 rows, but when i'm using the not equal, not just that 108 rows are missing. I...

I have just tested it, but unfortunately this is not the problem. My guess is that the problem is with the "<>" sign, now it's giving me more less rows than it should. I have to exclude that exact word and nothing else, but now it's filtering a lot more :(

I have edited it a bit, hope it makes more sense now

[SOLVED] adding criteria to a query Hi All, I have one datatable and i have to list the duplicates from it based on different criterias. It contains invoices, we would like to avoid duplicated payments. I'm struggling with a query. Basically i have a working one, i have to add one more...