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)
