Update field with Aggregate Error

Neal · July 27th, 2009, 06:00 AM

Hi,

I have an Access 2003 table that contains 2 fields:

AgeInDays (data type is double but which are whole numbers from 0 onwards)
WeightInKg (Data type is double with default as 0)

I need to run a query which is an 'Update to' the WeightInKg field
which is

Code:

Sum(0.0000000013*[AgeInDays]^4-0.0000140175*[AgeInDays]^3+0.0063725683*[AgeInDays]^2+0.022113072*[AgeInDays]+1.8089135351);

The resulting error is 'You tried to execute a query that does not include the specified expression "WeightByKg" as part of an aggregate function"

If I add 'FROM tblCalculatorReference GROUP BY tblCalculatorReference.[WeightByKg]' to the end of the expression, then an error message is displayed as 'containing invalid syntax'.

Can anyone help please?

Thanks in advance,