>Great, thank you for your help. I created a new Thread under Visual Foxpro - Crystal Reports.
>
>Can you please help me by taking a look at it and seeing if this can be done directly with Crystal Reports?
>
>Thank you again.
>
>John

I have never used Crystal Report to access a SQL database. I would be of no help.