I need to compare the value of 2 fields to see if the value(s)change when I read the next record. If the first field remains the same but the second field changes I need to know - would probably display a value of 1 if it changed. I am not sure how to set the variables up so they correctly update their values.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Variables - comparing 2 fields
- Thread starter Jake1
- Start date
IanWaterman
Programmer
Don't think you need variables. Assuming your fields are Field1 a Field2. Your formula would look something like
If Previous(Field1) = Field1 and Previous(Field2) <> Field2 then "1" else "".
YOur first record will be null and therefore blank. Previous is a crystal function.
Ian
If Previous(Field1) = Field1 and Previous(Field2) <> Field2 then "1" else "".
YOur first record will be null and therefore blank. Previous is a crystal function.
Ian
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
- Locked
- Question