Data Reports

Data Reports - I need to get data from more than one table for use in a report - Can anyone tell me how to do this - using vb 6 and Access 2000

Thanks

You can build an SQL statement in VB (using Access syntax) and append it to the Access 2000 QueryDef or Hard code a Query in your Access 2000 back end. The query can then be used like a recordset.
There are other ways be these are the simplest.