Hello,

I'm using VB6 + Microsoft access and crystal report 8.5. I am able to create a report using "Add database" from crystal report. However, this way I only can create a report for master table (inventory, employee, etc..)

The problem is how can I create a report if I must query 2 or more table from the database and then using this query result as my report ?

In this query, I also need input from user. example : create a sales report.
In my VB form, I have date time picker control. User should select the sales report date. Using this date (inputted by user) then I query tables in database.
My sales report is based on this query result.

How could I solve this ?

Hopefully, someone could help me.

Thank you
-Budianto-