[Access 2003] Sql statement - how to return a value in a union...

Hi,

I have two tables which have data and I also would like to add a row of 0 data to the unioned query.

The two tables unioned together works, but in Access it wants a table to out put the values I want with.

eg

Code:

---

Select table1.field1,count(table1.field1) as TheTotal
From table1
group by table1.field1

Union all

Select table2.field1,count(table2.field1) as TheTotal
From table2
group by table2.field1

Union all

select 'Received',0
From tablewithonerow

---

the received bit is where I would like to not use a table.

Any ideas? I mean I can use the above, but I need to reference a table and later on that record might be deleted/archived which would stop this code running (and probably cause some one a small headache ;)