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