469,601 Members | 2,221 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

Totals "Sum" not appearing.

5
Hello.

There is a problem in one of my forms, which also applies to reports in the same way... there is 3 fields Price and Quantity and Total Price. The field Total Price is made in expression builder, and is set to be a Currency(actually Euro) format.
Expand|Select|Wrap|Line Numbers
  1. =[Price]*[Quantity]
It calculates the total price... but in Totals i cannot acess the function Sum. only None or Count. Can this be solved in any other way?
Apr 25 '07 #1
5 3931
MMcCarthy
14,534 Expert Mod 8TB
Hello.

There is a problem in one of my forms, which also applies to reports in the same way... there is 3 fields Price and Quantity and Total Price. The field Total Price is made in expression builder, and is set to be a Currency(actually Euro) format.
Expand|Select|Wrap|Line Numbers
  1. =[Price]*[Quantity]
It calculates the total price... but in Totals i cannot acess the function Sum. only None or Count. Can this be solved in any other way?
Set Total textbox to

Expand|Select|Wrap|Line Numbers
  1. =Sum([Price]*[Quantity])
Mary
Apr 25 '07 #2
Knuxus
5
Set Total textbox to

Expand|Select|Wrap|Line Numbers
  1. =Sum([Price]*[Quantity])
Mary
Well i did it in Code Builder but now it gives me an #Error

Maybe i should set it anywhere else?
Apr 26 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Well i did it in Code Builder but now it gives me an #Error

Maybe i should set it anywhere else?
Is your textbox in the form footer?
Apr 26 '07 #4
Knuxus
5
Is your textbox in the form footer?
I tried, but nothing happened..

My form actually is a split form, which the totals are in table-like form.. and i would like to have it appear like the normal totals appear in the end of a table... of access 2007.
Apr 26 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
I tried, but nothing happened..

My form actually is a split form, which the totals are in table-like form.. and i would like to have it appear like the normal totals appear in the end of a table... of access 2007.
You can't do that. You can only put totals in a form footer.
Apr 26 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Thomas Qi | last post: by
10 posts views Thread by =?Utf-8?B?Q2hyaXMgRy4=?= | last post: by
4 posts views Thread by MarcuEusebiu | last post: by
17 posts views Thread by David C. Ullrich | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.