Return all values from two queries

[matteu1]

I have two select queries. Query1 has budget figures and Query2 has actual figures, all figures are tied to account numbers. I would like to join the two and produce a query which will show budget vs actual. My problem is when qry1 has an account qry2 doesn't have an vice versa. I have tried a union query but receive a non unique column refrence error.

SELECT qryactual.account,qryactual.prior_7_activity
FROM qryactual
UNION ALL
SELECT qrybudget.account,qrybudget.period_1_budget
FROM qrybudget;

Thanks in advance!