Joined: 19 May 2011
Online Status: Offline
Posts: 106
Topic: Comparing fields in different tables Posted: 24 May 2011 at 10:13am
I have a report that i am pulling information from a informix database and an access database. The report is mostly compiled from information in the informix side what i need is to have the line highlighted if the name exists in a table from the access side. I tried the using a formula if field a from the one = field b of the other in the format editor but it says th result must
be a number. i tried another way
if {tabel 1.field A} = {table 2.field A} then "LTL" but that acts like a select statement and only shows the the items that are in both tables if i add else"norm" at the end then it adds norm in the space
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
