Does anyone out there know how to format the following ACCESS statement in SQL? SELECT pat_id, IF(datafield>0,datafield+52535,datafield-12785) FROM pat Thanks in advance Richard
Forum Rules