Access formula

[Zeebow]

I have created this data base for water flow test and need to know how to write the formula for "K of Curve". The form looks like this:



Static Risidual Flow K of Curve
82 73 1404 468

K of Curve = flow/sqr(static - residual) ie. 1404/sqr(82 - 73)=468

[Zeebow]

Static = 82
Residual = 73
Flow = 1404
K of Curve = 468

[Missinglinq]

Exact syntax depends on where you're trying to do this:

In VBA Code:

Me.[K of Curve] = Me.Flow/Sqr(Me.Static - Me.Residual)

In the ControlSource of an Unbound Textbox:

= [Flow]/Sqr([Static] - [Residual])

In Query Design:

[K of Curve]:[Flow]/Sqr([Static] - [Residual])

Linq ;0)>

[Zeebow]

Thank you for your help, it is much appreciated.