Newbies radish Posted February 27, 2006 Newbies Posted February 27, 2006 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 Posted March 1, 2006 Posted March 1, 2006 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.
Newbies radish Posted March 1, 2006 Author Newbies Posted March 1, 2006 That is great! Saved me hours of messing about! Much appreciated Radish
Recommended Posts
This topic is 6859 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now