Software

Ask something
Discussion Locked

Displaying Yes/No in MS Access

0 helpful
3 replies

by cmugarura

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, i am designing a database for a patient monitoring system, i have a table with values 0, 1, but on the form i want it to display Yes (1), No (0). the values Yes/No are for patient wards e.g patient referred to Pediatrics (Y), Surgery (No), Medicine (No)

3 replies

by hhicks

I don't know if you have tried the old switch command, but you can do this;
Switch([fieldname]Like "Pediatrics","No",[fieldname]Like"Surgery","No",[Fieldname]Like "Medicine","No")
You can also have different fieldnames with this command. Good Luck

This discussion is closed to new replies.