Creating a Report Based on a Table. Choose Reports on your Objects menu, then choose Create report using wizard:
In the window for the New Report, click on the pop-down menu and choose your original Table1. Then click OK.
In this sample report, let's say we only want to print out names and birthdays for a birthday list. I would only want to include First Name, Last Name, and Birthdate fields in my report. So I would select each of these one a time and click on the arrow to the right. Then each field will move from the left column to the right column as I click on it. The right column is what I'm planning to include in my report:
Click on the Next button. Skip over Grouping -- we don't need this, click Next again. On the next screen, you can sort if you need to, or you can just skip and click Next again until you get to this screen:
Choose either Columnar or Tabular at this point -- your choice. Then click Next again. You can then choose how you want the basic design to look. This can be any choice you want:
Then choose Next again. On this screen you will rename your report to reflect what it contains by typing in a new name. This one has been renamed from Table1 to Birthdays:
Now you can click Finish! You will then see how your report will look if you were to print it:
Creating a Report Based on a Filter. Let's assume that you have already created a filter under the Query view and you want to create a Report that will reflect the filtered data. When you create a Report on a Filter, first go and open the Filter under your Queries and PERFORM THE FILTER (that is, PUSH THE FILTER BUTTON) so that you only have the filtered information up. Then leave the filter OPEN. If you cannot see your Access Tabs to then go to Reports, move the open Filter window down until you can see your tabs. (To move a window, click in the blue title bar area and drag it where you want it).
