Format Union Query
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Format Union Query
I have a Db that has a union query. The numbers are formatted double in the table. When the union query is run the values displayed are double. How may I format those numbers to currency? I found out that the union queries have the property sheet greyed out.
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Format Union Query
You can apply currency format to any text box bound to that field on a form or report. There is no need to format it in the query.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: Format Union Query
I knew you would say that.
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: Format Union Query
OK small issue with the union
Here is a portion of the union. What I intended is to sum all the hourly data, but what I have displays all of them. What changes do I need to make for the union to sum all the different hourly data?
Code: Select all
SELECT Hourly, CountOfProfit, SumOfProfit
FROM [quThreeOclocktrades]
union all
SELECT Hourly, CountOfProfit, SumOfProfit
FROM [quFourOclocktrades]
union all
...
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Format Union Query
If I understand your question correctly, create a new query based on the union query that sums the data.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: Format Union Query
A normal query, I guess.
Yes that worked. Thanks
Yes that worked. Thanks