I have 2 TABLES from 2 different DATABASES.

 

TARGETCUSTOMERS table is an excel spreadsheet with fields:

CODE

ACCMANAGER

TARGET

 

CUSTRANSACTIONS table is located on our main database with fields

CODE

QTY

INVOICENUMBER

BRAND

etc etc.... (basically all the transaction data)

 

 

I have set up the report, and linked the tables like:

 

TARGETCUSTOMERS.CODE --->  CUSTRANSACTIONS.CODE  

(Left outer join) (Not enforced)

 

 

problem:

 

Grouped by TARGETCUSTOMERS.CODE.

 

these are a few accounts in the TARGETCUSTOMERS table:

 

4PBTREB

4PENTO

4PENISTO

4ROGER

4ROGBAR

 

When I drop the CUSTRANSACTIONS.QTY field into the groupheader,

 

4PENISTO dissapears from the report.

 

The select expert filters to only show the last 3 months data, and 4PENISTO has not purchased anything in the last 3 months, which would mean that there is no data to display.

 

But I thought, using the LEFT OUT JOIN to link the tables, would still show this customer in the report, but with a 0 qty.

 

 

Am I missing something simple here? do I need to include some isnull somewhere?

 

 

I dont have this problem when I have done similar linking before, BUT previously I have only ever used tables from the same database.

 

 

Can anyone help?