M
mcl
Is there a way to set formats, like number of decimal places, in a union
query?
query?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
You can try this --
SELECT Union1.XX, format( [Union1].[YY ],"0.000")
FROM Union1
UNION SELECT Union2.XX, format( [Union2].[YY ],"0.000")
FROM Union2;
SELECT Union1.XX, format( [Union1].[YY ],"0.000")
FROM Union1
UNION SELECT Union2.XX, format( [Union2].[YY ],"0.000")
FROM Union2;
M
mcl
That worked fine. I have another question which I will give it's own title.
KARL DEWEY said:You can try this --
SELECT Union1.XX, format( [Union1].[YY ],"0.000")
FROM Union1
UNION SELECT Union2.XX, format( [Union2].[YY ],"0.000")
FROM Union2;
mcl said:Is there a way to set formats, like number of decimal places, in a union
query?
M
mcl
Actually I found a better way myself. Just create another query that calls
on the union query for input. I can set formats easy doing that.
on the union query for input. I can set formats easy doing that.
mcl said:That worked fine. I have another question which I will give it's own
title.
KARL DEWEY said:You can try this --
SELECT Union1.XX, format( [Union1].[YY ],"0.000")
FROM Union1
UNION SELECT Union2.XX, format( [Union2].[YY ],"0.000")
FROM Union2;
mcl said:Is there a way to set formats, like number of decimal places, in a union
query?