03-21-2006, 09:41 PM
I have a union query that consolidates from three parameter queries. I understand that the returned dynaset is not updateable as it is the result of more than one query; however, my understanding is that this should not affect the display format settings of the original tables...but it does. Example: fields that are designated Yes/No (which I have set to display as checkboxes) are displayed in the single queries just as they are set in the tables...but in the union query they are displayed as their corresponding "-1" and "0". If I were the only one looking at the resultant data, no problem. Unfortunately, the data is viewed by several people who are less conversant with Access. Is there a way for me to force the union query to retain the original table formatting and display the appropriate fields as either Yes/No or as checkboxes?