union query problem

[darkhat01]

I created a union query, that shows all the Highs and Mediums. My question is if a table does not have a field that is in all the other table how do you create field and set it to High. This Union query runs, but ask me to set the value for [Criticality of Risk] on the Open AF Issues Query. So I have to type “High” I would like this to be automated.

What I did:

SELECT A.[ Open Issue Tbl.ID] AS [IDCount],
A.[Criticality of Risk] AS [Criticality of Risk],
A.[Database] As [DataBase]
FROM [Open S Issues] A

UNION ALL SELECT B.[ID] AS [IDCount],
B.[Criticality of Risk] AS [Criticality of Risk],
B.[Database] As [DataBase]
FROM [Open Tangents] B

UNION ALL SELECT C.[AF Number] AS IDCount,
[Criticality of Risk],
C.[Database] As [DataBase]
FROM [Open AF Issues] C;

Thanks…

 

[KeithG]

You need to use the below syntax

"High" As [Criticality of Risk]

 

[darkhat01]

Thanks, that worked....