In a word - No. The problem is that you want to store yes or no in the table but you want to return the column name meaning on the report.
You could use an IF statement on the report field to get around this. i.e if the column is called WRITTEN on the report use a custom formula:
=iif([WRITTEN]=true,"Written"," - ")
I'd do one of these for each of the yes no fields.
Another way to address this, a lot of people would use (including me), would be by using codes to store against (in a text column) instead of yes/no columns. These can then be commonly looked up from a single descriptions table later.
Hope this helps
Last edited by sqlappboy; 10-12-05 at 11:06.
DAO/ADO/VB.net/VBA/Access2K/Excel2K/SQL2000/Essbase/OFA/Oracle OPM, IM, EAM/Discoverer/ SQLPlus