I am a virgin to report writing, please help me.

I have an application written in VB6 and uses ADO and Access 2000. I need to to create reports from multiple tables, I would assume by using SQL. If I were to create them in Access, can I send variables to the SQL in Access to create the report?

Would it be easier to just create them using the built-in Data Report? If so, anybody have or know of any any examples I can see?

I tried to go through the DataReport and build the report, but it seems I need to do it through code if I have a password on my database, is this true?

Thanks for any help.