When using certain criteria options in query the results change
This is most likely a result of using a criteria filter that uses the 'Only return records that do not match any of the selected values' option. Results will vary depending on whether this is selected or not. When switching from One of to Not One of we see that this option becomes unchecked. To resolve ensure this option is marked correctly.