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,
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05