Yes/No format to display simply Y or N

S

smaumau

Registered User.
Local time
Today, 12:08
Joined
Feb 23, 2006
Messages
32
How can you have a Yes/No format to display simply Y or N on a report?

Thanks
 
One way:

MyNewFld: iif([myYesNoFieldName],"Yes","No")
 
You must log in or register to reply here.

Similar threads

J
Data model for recruitment database with reserve list
2
Replies
30
Views
1,262
Ken Sheridan
Ken Sheridan
A
Solved How to add text to a null value field in an access report
Replies
18
Views
729
Ken Sheridan
Ken Sheridan
A
Counting specific numbers in textbox of two or more rows , (no duplicates)
Replies
12
Views
1,282
CJ_London
C
Technics
Working with Timesheet Form
Replies
10
Views
511
Technics
Technics
C
Inventory- hold stock level or not
Replies
10
Views
948
The_Doc_Man
The_Doc_Man

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom