Access 2007 reports are built from queries, data retrieved from one or more tables. You can save time by using the format of an existing Access report in another. When you copy an existing report in Access, its data, design and formatting are retained. You can use the Record Source property to customize the data so it pulls the correct query for your report. The Record Source property is visible in Design view. Writer Bio
