missing records in query

[rick roberts]

i have a query that contains two tables one contains the member details the other their transactions. the query is to show all members and transactions however if there is no transaction then the member details do not show - -the query only shows members with transactions . the query does have grouping to give totals of the transactions

 

[Michael J Ross]

You need to change your joins between the tables, currently they are inner joins which only pick up records if they exist in both tables, you need to use a left outer join between the member and transactions tables, this will select all member records and transaction records if they exist.

To change the join double click the join lines between the tables

 

[rick roberts]

thanks

so simple when you know how -- thanks fro the rapid response - worked perfectly