alternate data viewing

  • Thread starter Thread starter Guest
  • Start date Start date
Manohar

You didn't indicate how "y" is stored. Is this a text field, one character
wide? Is this a Yes/No field (in which case, the data base stores a 0 or a
1 (+/-, depending on the backend).

If you are using a query, you can use the IIF() function (immediate if):
IIF([YourField] = 'y', "Yes", "No")

(your actual syntax may vary)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Merging" Yes/No Fields in a query (MSAccess 2007) 4
VBA - retrieve data on last create named range from previous inserted named range 0
Retrieve data from Access database and fill data in form 0
Help needed with IIF in my query 14
Parameter queries 2
Another most-recent date query 0
Append Data Type Text Y/N to Data Type Y/N in Query HELP! 1
Creating a "grid" of data 3

Back
Top