Thread: [Solved] 'If... then... else' - output dependent on multiple fields
View Single Post
 
Old 01-12-2012, 08:09 AM
SiBrad SiBrad is offline Windows 7 32bit Office 2003
Novice
  
Join Date: Jan 2012
Posts: 3
SiBrad is on a distinguished road
Default 'If... then... else' - comparing two data fields
Me again!

I want to make an "If... then... else..." field that compares two fields from my data source. Basically, I want the field to express "if 'X' does not equal 'Y', print 'X'" where X and Y are two text fields in my database. As it is, I can express 'if 'X' does not equal [fixed value] then...' but it doesn't seem to allow me to compare it to another field.

Any ideas?
Reply With Quote