By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Union query in sql issue

P: 1
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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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.