Union query - adding a single value column with SQL

[smatchymo]

I'm practicing Access with a fantasy football database. I have union queries that list the top X amount of players at a position each week. Here's a snippet of the SQL:

(SELECT top 10 qrySortPointsDef2016.Team, qrySortPointsDef2016.Week, qrySortPointsDef2016.TotalFPtsFROM qrySortPointsDef2016
WHERE (((qrySortPointsDef2016.Week)=1))
ORDER BY qrySortPointsDef2016.TotalFPts DESC)


UNION ALL


(SELECT top 10 qrySortPointsDef2016.Team, qrySortPointsDef2016.Week, qrySortPointsDef2016.TotalFPts
FROM qrySortPointsDef2016
WHERE (((qrySortPointsDef2016.Week)=2))
ORDER BY qrySortPointsDef2016.TotalFPts DESC)


UNION ALL


(SELECT top 10 qrySortPointsDef2016.Team, qrySortPointsDef2016.Week, qrySortPointsDef2016.TotalFPts
FROM qrySortPointsDef2016
WHERE (((qrySortPointsDef2016.Week)=3))
ORDER BY qrySortPointsDef2016.TotalFPts DESC)

Is there a way to have the result include an extra column that contains the same value for all records. For example, my current results are Team, Week, TotalFpts. I would like Team, Week, TotalFpts, and Tier. Then every field would have a 1 in the Tier column.

Thanks in advance!



Edit: I should add that I have a fair amount of these. If possible I would like to use the SQL of the existing union queries to make this happen. I don't really want to add a bunch of new queries using the union queries as the source to do this.

[Micron]

IF Tier is a number field, try
SELECT top 10 qrySortPointsDef2016.Team, qrySortPointsDef2016.Week, qrySortPointsDef2016.TotalFPts, 1 AS Tier FROM qrySortPointsDef2016...
otherwise if it is text, "1" AS Tier...
You will have to add this to every union part because each part must have the same field count.

[June7]

This is a calculated field, just include in each SELECT:

1 AS Tier