Multiple records with the same SSN (linking field)

[pokerace]

C10

I’ve created a report that is using two data sources; one of them is an Excel spread sheet, the other based on Interbase 7.1. I am linking the two needed tables from each source by SSN. I pull totals data from the Interbase source, group by SSN and then use category information from the Excel spreadsheet. Some people in the Excel spreadsheet are listed more than once (as in more than one row) and that means that they are in multiple categories, but since the same social security number is used, I can only pull the one set of data from the Excel spreadsheet.

Does that make sense? If not I will try to explain it better.

How can I get passed this issue so that each Excel row that is counted even if they have the same SSN?

 

[synapsevampire]

I assume your concern si that you cannot select a Left Outer join wehn using the 2 data sources.

You have 2 reasonable options:

Create an MS Access database and LINK (not import) the 2 datasources (Use the File Type ODBC).

The create a query in Access using a Left Outer and use the query as the report data source.

The alternative would be to create a subreport for the spreadsheet and link via the SSN, you'll get both rows in the subreport.

The latter will prove slower and less flexible, but it elimiantes the need for Access.

-k