Searching

[radish]

I need help to do a search comparing 3 fields.

I have 4 feilds set up:

1. Item

2. RRP1

3. RRP2

4. RRP3

I want to list all 'items' where 'RRP2' or 'RRP3' is NOT equal to 'RRP1'

Is this easiest using CASE? or just a script...any suggestions/advice?

Thanks

[Ender]

Try this in a calc:

RRP2 <> RRP1 or RRP3 <> RRP1

It's boolean logic, so the result will either be 1 or 0.

Then perform a Find for 1 on that calc field.

[radish]

That is great! Saved me hours of messing about!

Much appreciated

Radish