Union Query

[michaeljfrey]

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?

 

[John Vinson]

Unfortunately, the
data is viewed by several people who are less conversant with Access.

Then they should never be presented with a query datasheet.

Create a Form based on the union query; you can set the format of the
form controls to whatever is needed. The users should simply be given
a switchboard command to open the Form; they really should never need
to see, much less use, the query window.

John W. Vinson[MVP]

 

[Kellyfrey]

Thanks John. I would have done that, however, this dataset is best
presented in datasheet format because there will always be multiple
rows of data. In a form you have to scroll through them one at a time.
In the datasheet, you can see them all at once. This has value when
you're on the phone with a customer and you can see all the results at
one time.

A form is what I would normally have done, but this is a special
circumstance...and, in fact, the users have requested the datasheet
format for the reason I stated and for their own reasons.

Thanks again.

 

[John Vinson]

Thanks John. I would have done that, however, this dataset is best
presented in datasheet format because there will always be multiple
rows of data. In a form you have to scroll through them one at a time.

That is simply incorrect.

A Form can be shown in Single view, Continuous view, or Datasheet
view. The Continuous view gives you the best of both worlds - the
control over layout and programming of a single Form, and the ability
to view as many records as will fit on the screen like a Datasheet.

Your choice though!

John W. Vinson[MVP]

 

[Kellyfrey]

Thank you very much, John. I never even tried that with a form. Learn
something new every day. I appreciate your help!