Hey.

I currently have a form that lists purchases of a client between certain times and is based on a query/ tables.
Everything works just fine except for when I try to calculate the total sum of the purchases, it prints #Error.

What am I doing wrong/ how am I supposed to do it?
The field including the total sum of purchases must be on the same form.

Thanks for any help in advance.

That's how I did it.
However, there's actually only one field. It uses just one field to list all prices of the purchases.
Don't think that sum sums up all the data in a single field?

This post was edited by eki11 on Nov 18 2013 09:58am

How does the field data look?

Colon separated?
123:456:789

Comma separated?
i,dont,give,enough,information

Random character separated?
maybe_if_i_dont_give_enough_information_more_people_will_help_me_?

There's functions to split (that's actually what it's often called) a string (which is what 123:456:789 would be) into several pieces. You could do something like =SUM( SPLIT( B1, '_' ) ) if the SPLIT function exists in Excel, though I'm not sure that it does (Google it!)

If your field data looks like;
a4cd4222frads55

Then this could help: http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
I found that link via GOOGLE.

No, it only includes the value.
But I have only made 1 field for every piece of information (name, price, etc) for all product.
The form lists all the products like this (simple version)

name:_______amount:______price:
product1_____10___________2
product2_____3____________7
etc..

And for that I have only made 1 of each fields (name, amount, price)

This post was edited by eki11 on Nov 18 2013 11:12am

You are confusing the word fields. One field is not a column or row, it is a cell.
You have a column where you list your Prices.
At the end of the Prices column, write =SUM( and left-click drag from 2 to 7 )
Like this; http://puu.sh/5mk7C/3faceeca90.png

Or why don't you look on youtube? Ever heard of youtube? How about google? Holy shit..
http://www.youtube.com/results?search_query=excel+sum&sm=3

Access =/= Excel.

My mistake, I must have been tired.

Access 2010: Creating a Totals Query
www.youtube.com/watch/?v=ehnwAJhnzC0

Found it on Google!

why don't you post your sql and we'll modify it?