Microsoft query in Excel returning a blank column when SSMS does not

Question

I'm using MS query to return data to Excel from SSMS.

When I run the query in SSMS it runs without error and all fields return with records (see bottom left). When I run the query in MS Query (to pull into Excel) one of my fields is now returning blank records (see bottom right). I thinking I have a conversion issue with the us.prod_qty field. It's datatype is float and I'm trying to convert it to a string.

Thanks for any help with this.