Setting Format in a Union Query?

[mcl]

Is there a way to set formats, like number of decimal places, in a union
query?

 

[Guest]

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]

That worked fine. I have another question which I will give it's own title.

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;

Is there a way to set formats, like number of decimal places, in a union
query?

 

[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.

That worked fine. I have another question which I will give it's own
title.

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;

Is there a way to set formats, like number of decimal places, in a union
query?