F16QQ08 in Visual Studio .NET

Creation Code 128B in Visual Studio .NET F16QQ08

To add a page number, use the Page property for the report. You can t see this property in any of the property sheets because it is maintained by Access. Access also provides the Pages property, which contains a count of the total number of pages in the report. To add the current page number to a report (in this example, in the Page Footer section), create an unbound text box control (delete the label) and set its Control Source property to ="Page " & [Page] & " of " & [Pages], as shown in Figure 16-10.

Tip You can change the value of the Page property in code You can reset the value of the Page property in a macro or a Visual Basic procedure that you activate from an appropriate report property. For example, if you re printing several multiplepage invoices for different customers in one pass, you might want to reset the page number to 1 when you start to format the page for a different customer. You can include a Group Header section for each customer and then use a macro or a Visual Basic procedure to set the Page property to 1 each time Access formats that section (indicating that you re on the first page of a new customer invoice).

Another task you might perform frequently is calculating extended values from detail values in your tables. You ll recall from 3, Designing Your Database Application, that it s usually redundant and wasteful of storage space to define in your tables a field that you can calculate from other fields. (The only situation in which this is acceptable is when saving the calculated value will greatly improve performance in parts of your application.)

You can use arithmetic operators to create complex calculations in the Control Source property of any control that can display data. You can also use any of the many built-in functions 573

16

16

16

16

16

16

Microsoft Office Access 2003 Inside Out or any of the functions you define yourself in a module. If you want, you can use the Expression Builder that you learned about in 7, Creating and Working with Simple Queries, to build the expression for any control. You let Access know that you are using an expression in a Control Source property by starting the expression with an equal sign (=). Note To use a field in a calculation, that field must be in the table or query specified in the Record Source property of the report. One calculated value that housing management might find useful is the daily revenue for each room. You could have calculated that value in the query that is the record source of the report, but you can also calculate it as an expression in a text box in the Detail section of the report. To add the expression you need, follow these steps:

16 16 16 16 16 16

2 In the Control Source property of the new text box, enter:

=CCur(Round([TotalCharge]/([CheckOutDate] [CheckInDate]),2)) Because you included the TotalCharge, CheckInDate, and CheckOutDate fields in the query, you can reference them in your expression. This expression calculates the daily revenue by dividing the total charge for the reservation by the number of days.

3 Set the Format property of the text box to Currency. 4 Set the Width property to 0.75 inches, move it close to the EmpName text box, and

line up the tops of the two text boxes. Also, make the height of both text boxes the same by selecting them both and then choosing Size from the Format menu and To Tallest on the submenu.

so that it stretches over your new text box. (Hint: The line control is difficult to select by itself because of the row of closely spaced labels on top of it. You can use the Select Objects tool to draw a selection box across the Employee label control and the line, then hold down the Shift key and click the Employee label control to remove it from the selection.)