SUM in form footer not working when opening in MS Access 2010

[osupratt]

I have a textbox in a form footer that is a basic SUM([Quantity]*[Price]) and has worked for years. it's a continuous form and I might have several lines of 'invoicing' that is done and each line has a total. I then total all these line totals in the form footer. it is a MS Access 2000 file format. we have been in a Citrix environment where we opened it using Access 2000, 2003, and 2007. We have now moved out of Citrix to a RDS or remote desktop and it now is opening up in MS Access 2010. This calculated field in the form footer does not work. it is just blank. I've had the control source = [Quantity] or =[Price] and I get the desired result. if I use the function SUM it does not work. = SUM([Quantity]) I get nothing. this should be something very easy but I have checked references and nothing is missing. I don't get it. does anyone have a clue what this might be?

[ranman256]

did you check to see if the query fields have the same spelling to what the form is adding?

and you put the = in the formula
=SUM([Quantity]*[Price])

also try putting the fields on the footer, (invisible)
txtQty = Sum([Quantity])
txtPrice = Sum([Price])
txtSum = txtQty * txtPrice (using text box names)

[June7]

None of the aggregate functions will work on any field? On any computer with 2010?

Is this a split design? Did you convert db files to accdb format?

[osupratt]

None of the aggregate functions will work on any field? On any computer with 2010?

Is this a split design? Did you convert db files to accdb format?

well once I converted to .accdb it worked. thanks.