Solved: Access Sum

alter_ego1981 · 19-Sep-2008, 08:42 AM #1

Hi All,

My brain has gone blank and i cant think how 2 do this.

I have a list of months each with a value in and i need to sum all these but i cant remember for the life of me how to do it.

Thanks

OBP · 19-Sep-2008, 08:51 AM #2

In a Query or on a Report?
Query use Totals and Group and Sum.
In a Report you can use "Running Sum" or an equation in an unbound field.

alter_ego1981 · 19-Sep-2008, 10:19 AM #3

Hi OBP,

its in a query at the moment as i need it to appear in a form

OBP · 19-Sep-2008, 10:40 AM #4

I have looked at your database and it would be much easier if you had a seperate table for the Values.

alter_ego1981 · 26-Sep-2008, 10:47 AM #5

Problem solved, thanks Tony

Tag Cloud
access acer asus batch bios bsod crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard mouse network printer problem ram registry repair router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!