Hi..
Can anyone please help me with an example of a report which displays data from more than one table.(It displays data from multiple records of some tables and single record of one table)

Thnks in advance!!!

Either use a query that joins the tables as the Recordsource or use Subreports.

Main report for the 1-side data and subreport for the many-side data usually produces the best results.