Embedded Files
In this tutorial we will create a simple report based on our Client Query
Select "Create > Report Wizard"
Choose "Query: qryClient" and move all Available Fields to Selected Fields
Lets group by TownCity
Leave the sort order (Access know yu want tosort by TownCity)
Choose the format for your report (I'll choose Block)
Change the title of the report to rptClient, and [Finish]
The following report is then displayed
Close the Print View (Top right on ribbon bar), and you will be taken to design view.
Using Design View you can change the layout of the report so that it looks much better on the page.
Which if you use "Report View" will show you
Note the difference between Report View and Print View is that the footer appears after the report content whereas in the Print View the Footer appears at the bottom of the page.
Adding the Time
Adding the Time
If you want to Add the Date to the footer, you can change the properties > Format to General Date (Right Click to show the properties window). If you want to have the Long Date plus the time you will need to add the time as a new text box.
Google Sites
Report abuse