How do I add a condition to an expression to only include rows where the values of 2 similar fields don't match?

[#1]

Hi,

I have a model where the same information about the population in the model comes from two fields from different sources (tables). To make it easier, let's say I have a list of SKUs for clothing articles, and each can be a S, M, L in size, and that I get the sizes from manufacturing data and from accounting data.

To validate my data, I want to create a table where only the records where the size values don't match.

So, I thought I'd try to include in the expression something like:

[Size from manufacturing]-=[Size from accounting]

But that didn't do the trick......

what should I do?

Thanks!

[#2]

Pardon me for asking naaive questions, but the part I don't get is the

[Size from manufacturing]=...

I mean if the condition gives (-1), what does it mean to limit the set to X=(-1) ?

[tresesco]

In fact it's a very genuine question that might come up in minds of many of us while we see such SET expression. One thing we have to understand that it''s not like searching '-1' value in that field. It's like 'Advanced Search'; like you can do in a list box search. For example:

=sum(Sales)>sum(Budget)

if e.g. invoked from a list box containing the field Salesman, the search would return all salesmen

with an associated sales value larger than their associated Budget.

Hope this clarifies.

[#4]

Huh. Very interesting. Many thanks!