Working with Attachment data type in Microsoft Access 2007
page 3 of 6
by Jayaram Krishnaswamy
Feedback
Average Rating: 
Views (Total / Last 10 Days): 18742/ 406

Creating a Report using the table

Some of the steps in creating a report will be abbreviated. This next screen shown in Figure 12 starts off with a Report Wizard which uses the DesignAttach Table.  It shows all the available fields in the table, DesignAttach. Notice the extra fields added to support the attachments.

Figure 12

 

In this screen all fields have been transferred to the right (Selected Fields :) using the >> button as shown Figure 13.

 Figure 13

 

This next screen shown in Figure 14 is another step of the Report Wizard where you may include grouping information.  No changes were made here.

 Figure 14

This next screen shown in Figure 15 is the Report Wizard sort order configuration step. Again only the EmpName is designed to be sorted in ascending order.

 Figure 15

 

Figure 16 shows the next step of the Report Wizard where the layout design is chosen. The columnar design is selected.

Figure16

 

In Figure 17 a style for the report is chosen. Access 2007 has a few more new styles in this step.

 Figure 17

 

In the window shown in Figure 18, the report needs to be provided with a title which can be different from the default which comes up. In the example the default radio button choice is accepted.

Figure 18

 

When you click the Finish button the report will be created and will be, as was specified, opened in preview mode.


View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 
Learn More
.NET Tools
asp.net shopping cart
asp.net chart control






Ads Powered by Lake Quincy Media
Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 8/29/2008 6:41:13 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search