>Hi Bill ----
>
>What is the relationship between these tables? What is the structure (at least what info is required)?
>
>
>>I need to build a report on the following tables
>>
>>Staff - People who work for the company
>>Aropen - Open AR records
>>Arhist - Closed AR records
>>
>>I need to run a report for all three silmultaneosly. I have tried multiple scans but can not get the right numbers. Anyone have any thoughts.
>>
>>TIA,

The relationship between the tables is a field called staff. The aropen table is accounts receivable active and arhist is accounts receivable historical. Both "ar" tables have the same structure.