Totals "Sum" not appearing.

[Knuxus]

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.

=[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?

[MMcCarthy]

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.

=[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

=Sum([Price]*[Quantity])

Mary

[Knuxus]

Set Total textbox to

=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?

[MMcCarthy]

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?

[Knuxus]

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.

[MMcCarthy]

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.