P
phil access
What is wrong with this expression?
cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)
cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marshall Barton
phil said: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?
P
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
bottom of a weir. This equation is supposed to convert height of water into
flow rate in cubic feet per second
Marshall Barton said:phil said: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?
M
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]
information in a later thread. The answers I see there seem
appropriate to me so I consider this thread closed.
--
Marsh
MVP [MS Access]
phil said: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
phil said:What is wrong with this expression?
cfs: (4.28*0.577*0.577351*([Field4])+0.004^2.5)Marshall Barton said: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?