Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Want different text to display in place of Yes/No on report

Status
Not open for further replies.

JSD

Technical User
Jan 18, 2002
189
US
Hello

I'm trying to get a Yes/No check box from a query to display as company owned/Emplyee owned. A hint in the right direction would be most appreciated...

Jeremy
 
Hi

In the query designer grid, take the checkbox column (chkEEOwned) and make it a claculated column ie put Owner:=IIF([chkEEOwned,"Employee Owned","Company Owned"

Hope this helps Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top