I actually have two questions.

1) I am created a summary page for data that is in a table. Here the function that I want to use.

IIf([Date Settled] Between #9/1/2003# And #9/30/2003#,Sum([Excess Mileage])).

I would like to set the report the table instead of a query. The Calculation is in the detail section and the Labels are in the report header section. It will just be a 1 page report. Is that the right fucntion to use or do I have to use a query?

2) Right now the aloignment is way off. The Labels are above the calculation. How do you align them?

Thanks!

1. Do you really want to embed dates in a report? Wouldn't it be better to use parameters?

It is better practice to use a querydef as the recordsource of the report than to use the table directly.

2. This is a pretty big topic. You can select multiple controls by using the shift key while you click. You can also "corral" several controls by "drawing" a rectangle around them. You can select an entire row by clicking in the ruler area on the left. You can then use the Format menu to choose various tools that will allow you to work with all the selected controls.