Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access sum columns in query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access sum columns in query

Resolved · High Priority · Version 2003

Reply Wed 5 Nov 2008, 09:46Delegate Kevin said...

Kevin has attended:
Access Intermediate course

Access sum columns in query

I have a query that i am running showing figures for each month of the year, and i just want to be able to add a "Total" column at the end, which adds the 12 month columns. Any ideas?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Tue 11 Nov 2008, 19:50Delegate Mark said...

RE: Access sum columns in query

Hi Kevin,

all you need to do is write into the next coumn of the query design grid, write into the field cell the following, or rather your version of it. Total:([col1]+[col2]+[col3])

Instead of col1 and col2 etc put the actual field names containing the values to be added. If you have 12 fields named Jan, Feb etc then you will have 12 terms in the expression ie [Jan]+[Feb]...

Regards, Mark (delegate)

Access articles

· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· When Is Microsoft Access Not The Best Choice For Your Business?
· Why a Microsoft Access Course Could Change the Way You Do Business
· Material covered on a Microsoft Access Course
· MS Access can promote teamwork

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

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips