Bulit Report off the queryForm

[BorisGomel]

Hello,

I have a query form that runs the query in query named qChecksQB . The query qChecksQB has all fileds that corresponding table ChecksQB has . There are five fields: checksN, ClaimN, ClientName, Date and Amount. I have done it following the tutorial found right here on the forum. Everything works fine , but I am just wondering that some query would be nice to put them in reports .For example , if user ( the db is located on the server of company and lot of people are using it and they are asking me of possibility to built a report off the query) runs query of few records so that report is not needed , but if the query included amounts and ClientName , Dates and a lot of records so that they would like to print this out , but how can I do program the built repot based on query that was just inquired . In another words, if user wants the print query out, he would like to be able to built the report right off the query form based on selections of query and print it out in the most simple user friendly interface b/c they only users.

Any suggestion will be greatly appreciated.



The Best Reagrds.

[alansidman]

Are you looking for a designed report? Use the Report Builder Wizard and make the query the recordset for the report.

If an Excel Spreadsheet will suffice, then use the Export Wizard to export the query to an excel spreadsheet.

Alan

[BorisGomel]

Thank you sir!!!

I did as you have suggested it .I built the new report off the query qChecksQB and placed a command button on query form with code in even procedure “On Click” to open this report . Now, users can open the report off the query they just have run.

Thank you very much.

Will mark as it is solved.
Regards.