summarise data
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Summarise data

Summarise data

resolvedResolved · Low Priority · Version 2003

replyReply Mon 21 Apr 2008, 17:14Delegate Elaine said...

Elaine has attended:
Access Intermediate course

Summarise data

Can the report wizard summarise data

For upcoming training course dates see: Pricing & availability

replyReply Mon 21 Apr 2008, 19:39Trainer Pete said...

RE: Summarise data

Hi Elaine, Thank you for your post, welcome to the forum, in answer to your question, when creating your report using the wizard, once you have chosen your source, table or query, and which fields you want included, you will be given the option to choose detail or summary, choose summary and click the summary options button which has become available. From the fields summary values selection, make your choices and click OK, continue with the wizard and your display will have the summarised data as chosen. I hope that has helped, if so please click the resolved link, best regards Pete.

 

Please browse our web site to find out more about
ms-access-course and other Microsoft training courses.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard