Now that you have identified which table or tables to select data from, objects need to be added from the table(s) to the report.
Access provides a very nice feature that allows you to easily select which objects you would like to appear on your report. In the toolbar at the top of the page, click on the button called ‘Field List’. (It looks like a piece of paper with writing on it.)
A small window will appear like the example below based on the Record Source selected earlier:
All of the fields that are available for the report to use will be listed.
To select one of these fields to be added to your report, highlight the object in the window, and then drag it to the location in the report where you would like this object to appear.
In the example below, four objects were chosen and added to the Detail Section of the report.
You will probably need to resize the object. To resize, click on the object that you wish to resize. You will notice small black boxes around the perimeter of the object like in the example below.
Move your mouse pointer over one of these "resizing boxes". When your mouse pointer displays a double-headed arrow, hold down the left mouse button and drag the object to the desired size.
You also have the option to move an object. To do this, move your mouse pointer until it displays a hand icon. Then hold down the left mouse button and drag the object to the desired location.
You may also want to resize your Detail Section of your report. To do this, move your mouse pointer over the bottom of the detail section until your pointer displays a double-headed arrow, then hold down the left mouse button and drag until the Detail Section is the desired size. The example below shows the results of resizing the objects and the Detail Section of the report.
Setting a Page Header >