programming a report?

  • Thread starter Thread starter w@m
  • Start date Start date
W

w@m

Hi,

I have linked data from another application into an access database; I have
a report on one of the tables which contains a numeric field with either a
'0', a '1' or a '2'.
Is it possible to generate a report which states 'Yes' instead of a '0',
'No' instead of a '1' and 'Don't know' instead of a '2', in short: can I
manipulate field content by means of a report?

TIA

W.
 
Place an unbound text control on your report with this as the ControlSource...
(ex. name txtStatus)

= IIF(YourNumField = 0, "Yes", IIF(YourNumField = 1, "No", "Don't Know"))
 
Back
Top