Competent Performer
Windows XP 
Access 2010 64bit
I have a union query where I select * (all) from both queries utilized. In those two queries many of those fields are formatted as standard, two decimal places. When I run the union query those fields lose their formatting. Is there sql code I can use to format all the number fields without having to select and format each individually? The fields that are dates and text all output correctly.
VIP
Windows 10 Office 365
Formatting isn't data, the query will only return the data, and if that means 10.00 is returned as 10 , then it's correct.
Generally speaking you shouldn't format results in a query, you should do it in the Form or Report control properties, then it doesn't matter what happens until your user needs to see it.
The only exception would be to maybe concatenate special characters or perhaps add FirstName & " " & LastName together or to output a number or data as a string.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Virtually Inert Person
Windows 10 Access 2016
The solution is to store the data as you want to see it? Store 10.00 not format 10 as 10.00.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Competent Performer
Windows XP Access 2010 64bit
argh. Not what I wanted to hear but what I needed to hear. Thanks.
Union Query to obtain a Freq Array Giving Syntax Error
Need Help With DLookup in Query: Handling Null (#Error) With Numeric Fields
Format two fields in a Union Query as Currency
Posting Permissions
Reply With Quote