How to Join 2 Queries

[frankis]

I am trying to do a mail mergre which I need to join two queries, one pulling all salary payments for a department and the other pulling stationary expenses, which i need in the one row.
I wantto join them on the department reference number, so the result would be
Department Salary Yr1 Yr2 Total Stationary Yr1
G03 Salary 20000 20000 40000 Stationary 20000

etc..

can anyone help me on this?

thanks
frankis

 

[PHV]

Tell the Query designer you want both Tables and Queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244