L
Lee
I have two tables which contain fields that are formatted
as currency. I used a union query to combine
corresponding fields into a single table. I then used the
union query as the basis for another query. My problem is
that now the fields that were showing as currency are now
formatted as text. I tried formatting the field of the
query as currency but no change occurs. When I export all
the results to Excel for further analysis, I have to
convert all these fields to numbers. The problem seems to
occur when the union query is run. Is there a way to
retain the correct formatting in a union query?
as currency. I used a union query to combine
corresponding fields into a single table. I then used the
union query as the basis for another query. My problem is
that now the fields that were showing as currency are now
formatted as text. I tried formatting the field of the
query as currency but no change occurs. When I export all
the results to Excel for further analysis, I have to
convert all these fields to numbers. The problem seems to
occur when the union query is run. Is there a way to
retain the correct formatting in a union query?