Hello all,

I have built in Acces a query that uses 5 tables to return, specifically 1 - The total expenditure in materials of a job and 2- knowledge of whether or not the Client is to charge TAX against labour.

The query performs perfectly
I had attempted for the whole day to build the query in VB6 and failed miserably. Building it in Access took me ten minutes.

Now that I have this query, how can I use it from my VB6 application?
I would like to fill a recordset with the results of the query so that I may run calculations against the expected tax deductions for an accurate yearly returns. Please be aware that this is an application to complete my University project, I am not about to base an organisations tax returns from an Access app.

All I have found so far is to use parameterised command objects, which I have never used before.

Any assistance is greatly appreciated.

Kind regards

Steve