aggregate function

[phil access]

What is wrong with this expression?


cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)

 

[Marshall Barton]

What is wrong with this expression?

cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)

As long as Field4 is a numeric type, there is nothing wrong
with it. But what does it have to do with an aggregate
function?

What result are you getting and what result did you want?

 

[phil access]

Field 4 is a list of values that represent the height of water above the
bottom of a weir. This equation is supposed to convert height of water into
flow rate in cubic feet per second

What is wrong with this expression?

cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)

As long as Field4 is a numeric type, there is nothing wrong
with it. But what does it have to do with an aggregate
function?

What result are you getting and what result did you want?

 

[Marshall Barton]

I see that you reposted this question with more complete
information in a later thread. The answers I see there seem
appropriate to me so I consider this thread closed.
--
Marsh
MVP [MS Access]

Field 4 is a list of values that represent the height of water above the
bottom of a weir. This equation is supposed to convert height of water into
flow rate in cubic feet per second

What is wrong with this expression?

cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)

As long as Field4 is a numeric type, there is nothing wrong
with it. But what does it have to do with an aggregate
function?

What result are you getting and what result did you want?