468,238 Members | 2,037 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,238 developers. It's quick & easy.

Union query in sql issue

I am joining multiple queries in a union query in sql and the data is formatting in random fashion. I then add this Format([Step 6: Final Summary].Shipmentsize,"0.00") which fixes it, but now I lose the column header "shipment size" and it labels it expr1008...any suggestions?
Sep 9 '08 #1
1 1051
2,878 Expert 2GB
Use alias

Expand|Select|Wrap|Line Numbers
  1. Format([Step 6: Final Summary].Shipmentsize,"0.00") as Shipmentsize
-- CK
Sep 10 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Paradigm | last post: by
6 posts views Thread by Eugene | last post: by
7 posts views Thread by KoliPoki | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.