Report SQL/vb search result!!

Hi,

I have a Access database where I connect to via. ADO in a vb project. In my vb project I have a search textbox and datagrid to list my search result (Sql).

Now I whant to make a report where my result from the search is in!

How and where can I do this with SQL..

I have made a report with everything from the Access database. In Data Envoriment I made a new connection, add new command and a child command..

Is there a vb/Sql shark out there??

Thanks :-))

Regards
Allan
vb 6 sp4