formating Union Query

[Rick Stahl]

I have a Union Query that displays correct values but in an unformatted
table. Is there any way I can format these fields (they are correctly
formatted in the original queries) and also change the displayed field names
? Thank you !

 

[Guest]

Don't do formatting in tables or queries. Do the formatting in the form or
report.
As to changing displayed field names, create alias names like this:

Select FooBah As Dinky

The original table field is FooBah, but when displayed will say Dinky

 

[Rick Stahl]

All right. Thank you ! This will work.

Don't do formatting in tables or queries. Do the formatting in the form
or
report.
As to changing displayed field names, create alias names like this:

Select FooBah As Dinky

The original table field is FooBah, but when displayed will say Dinky