Hi Guys,

how do i go about making a query from an access databse in VB6?

I have a databse file. data.mdb and i need to make a query to extract data from the recordsets and display them into a form or data report. for now, i am collecting this data and sticking it into another database file. then displaying it from there.

there should be a way to make a query and make this easier.......

Any input is appreciated.
thanks in advance.
EL.