Sum in Form Footer Problem

[Mariano]

I have been battling this problem all night... very confused.
I have a form based on a query called [preview query]. In this query i have
a field called Extendedprice.
The form is a continuous form, and in the footer i have:
=sum(extendedprice)

In theory this should give me the total of the extended prices for all
records, right? Well, I am only getting #Error.
I have absolutely no idea what i am doing wrong, i have tried looking at
other posts regarding this problem but nothing has helped.

Any ideas?

 

[tina]

what's the name of the textbox control where you have the Sum() expression?
if it's called Extendedprice, change it. Access will not allow a circular
reference.

hth

 

[Mariano]

The textbox is named subtotal.
I have done this before with no problem, I have NO idea what could be
happening.

what's the name of the textbox control where you have the Sum() expression?
if it's called Extendedprice, change it. Access will not allow a circular
reference.

hth

I have been battling this problem all night... very confused.
I have a form based on a query called [preview query]. In this query i have
a field called Extendedprice.
The form is a continuous form, and in the footer i have:
=sum(extendedprice)

In theory this should give me the total of the extended prices for all
records, right? Well, I am only getting #Error.
I have absolutely no idea what i am doing wrong, i have tried looking at
other posts regarding this problem but nothing has helped.

Any ideas?

 

[tina]

is Extendedprice a *calculated* field in the query? if so, Access may be
reading it as text rather than a number. make sure you're entered the field
name correctly in the subtotal textbox control, then try including a
conversion function in the expression, such as

=Sum(CCur([Extendedprice]))

hth

The textbox is named subtotal.
I have done this before with no problem, I have NO idea what could be
happening.

what's the name of the textbox control where you have the Sum() expression?
if it's called Extendedprice, change it. Access will not allow a circular
reference.

hth

I have been battling this problem all night... very confused.
I have a form based on a query called [preview query]. In this query

i
have

a field called Extendedprice.
The form is a continuous form, and in the footer i have:
=sum(extendedprice)

In theory this should give me the total of the extended prices for all
records, right? Well, I am only getting #Error.
I have absolutely no idea what i am doing wrong, i have tried looking at
other posts regarding this problem but nothing has helped.

Any ideas?