souvik banerjee said:
how to generate a report contains all data of a said database? what is the
sql query for it and how do it fire?
If you have one table, it will likely be relatively easy... in the database
window, click on the Reports tab, then on New, and choose one of the Report
Wizards, in which you specify the table name. If you have multiple tables,
then it will depend on the relationships between the tables, and the
specific data you have -- as we don't know about either of those issues, you
would really need to clarify before you could expect anyone here to be able
to assist you.
Larry Linson
Microsoft Office Access MVP