Possible ISNULL problem?

[grangers]

Hi All

I have 3 tables from which I am trying to create a report...the 3 tables are:

glchart - which contains account code summary & fields account_code, po_no.

pur_line - which contains details of purchase orders, including the account code & fields account_code, po_num, po_item.

receipts - some purchase orders will have been 'received' - this contains those detail lines & fields account_code & po_no & po_item.

The problem I am having is that not all purchase orders held on pur_line will have receipts held against them. What I need is to be able to search by account code to see all outstanding purchase orders & receipts.

I believe that an ISNULL statement might help me, but am rather stuck as to how............

Thanks very much in advance.

Julie

 

[lyanch]

Go to the SQL design window, right click on the join to receipts and change it to a left outer join (assuming that receipts is on the right hand side). Then you will get all purchases and any receipts that match. If you need to place selection criteria against receipts you will have to deal with the isnull then.

Lisa