Categories:
Administration (10)
Adware Spyware (7)
Apache (10)
Bluetooth (125)
DOS Commands (1)
Edge (28)
General (2)
Internet Explorer (217)
Media Center (12)
Media Player (11)
Mozilla Firefox (18)
PHP (15)
Programming (8)
Security (4)
Silverlight (15)
Tips (17)
Tools (218)
Tutorials (5)
Windows 10 (166)
Windows 7 (636)
Windows 8 (1091)
Windows Phone (33)
Windows Server 2008 (165)
Windows Server 2012 (84)
Windows Server 2016 (23)
Windows Vista (52)
Collections:
Other Resources:
Generating a Standard Report
I have a table with many record in a MS Access table. How do I create a report to list all records in the table?
✍: FYIcenter.com
Assuming that you have a table called Transaction in MS Access 2000 with these fields:
This tutorial shows you how to create a standard report for a given table.
1. Click "Reports" in the Objects list. Then double click “Create report by using wizard”. The “Report Wizard” shows up.
2. Select “Transaction” in the Tables/Queries field. Click “>>” icon to select all fields. Then click “Next”.
3. If the “Do you want to add any grouping levels?” screen shows up, click “Next” to skip it.
4. On the “What sort order do you want for your records?” screen, select “trans_date” as the sorting column. Then click “Next”.
5. Select “Tabular” as the layout and click “Next”.
6. Select “Corporate” as the style and click “Next”.
5. Enter “Transaction Report” as the report name and click “Finish”.
A report will be generated as shown in this picture:
2010-04-10, 10183👍, 0💬
Popular Posts:
This tutorial shows you how to boost performance by stopping and disabling unnecessary services on W...
A collection of 7 tutorials on Internet connections with wireless routers covering: What are require...
What is service "wudfsvc" and library "wudfsvc.dll" on Windows Vista? "wudfsvc" is a system service ...
Where to find tutorials on using Windows 7 Installed Programs and software? Here is a collection of ...
What is GoogleUpdaterService.exe - Google Updater Service? GoogleUpdaterService.exe is binary file o...