Combine fields in one textbox on a report

cbialzik

Registered User.
Local time
Yesterday, 19:18
Joined
Feb 21, 2006
Messages
15
I have a database with phone numbers, pager numbers, etc. Some people have pager numbers that are private, not published to other employees. I currently have a report that will bring up a list of people by department, etc that shows their phone and pager numbers along with other information. Right now it does not show any private pager numbers. The user of the db would like to have the private pager numbers on the report but would like them to show up in the Pager column along with a * if it is a private pager number. How do I make the textbox show both a pager number and a private pager number? Hope this makes sense. Thanks! :)
 

Users who are viewing this thread

Back
Top Bottom