Sambuca Posted July 7, 2002 Posted July 7, 2002 Just need to do a simple calculation but I never d calculation so i'm not sure how to write it out. I need: If "FieldA" is Greater than "FieldB" show "FieldA" Else Show "FieldB" i mean basically thats it I just can't get the calculation to read. do I use = instead of Show ?? I'm just not entirely sure. Thanks Dudes.
mborgens Posted July 7, 2002 Posted July 7, 2002 If(FieldA > FieldB, FieldA, FieldB) It reads: If FieldA is greather than FieldB then FieldA if not FieldB. A couple of thoughts: can FieldA = FieldB and make sure you match the calculation result with the data (the options are text, number, date, time or container. This is done in the calculation screen right below where you write your calculation.
Sambuca Posted July 7, 2002 Author Posted July 7, 2002 Ahh it was that easy. Thanks dude. This little program is a ripper!
Recommended Posts
This topic is 8246 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