Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

summarise data

ResolvedVersion 2003

Elaine has attended:
Access Intermediate course

Summarise data

Can the report wizard summarise data

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.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.