Changing from # to text on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a report that presents data that is taken from a value field. In other words, 0 = Schools and 1 = Private. When the report opens - it shows the number, and I want to show the actual text. How can I change this when the report is opened

Thanks

Eric
 
I would have a separate table called something like "refSchoolTypes",
meaning it is a reference (lookup) table for the schools. It would have a
primary key holding the number and a text field holding the type of school.
Then in the query behind the report, I'd join the refSchoolTypes table to
the main table and make the SchoolText field the control source for the
control.


--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Eric Chajmovic said:
Hello,

I have a report that presents data that is taken from a value field. In
Click to expand...
other words, 0 = Schools and 1 = Private. When the report opens - it shows
the number, and I want to show the actual text. How can I change this when
the report is opened?
 
Back
Top