query one table with criterion from another table

[rkmaitra]

Hello,
I have a table (tblMain_Table) where each record has a field called 'Type' and 'Deposit' and 'Withdrawal'. The 'Type' field has a Lookup criterion and gets its values from another table called 'tblType_Lookup' where the values are stored under the field heading of 'Type Name'.
I want to create a query that will return the tmotal deposit/withdrawal for each type in the 'tblType_Lookup' table from the tblMain_Table.
I have tried to include the two tables in my recordset, then creating a left outer join between the fields of 'Type Name' in the tblType_Lookup table and 'Type' in the tblMain_Table. When I run this, the query returns a blank grid with no results. What am I doing wrong?
Any help will be appreciated.
Many thanks,
Rudra

 

[GinaWhipp]

Without seeing your tqbles I have to wonder if that field in tblMain is filled in. If not, you will need a RIGHT JOIN.