Trying to calculate volume?

[Bec_FS]

Hello, I was wondering if there was a way to calculate volume in a query. I
have the formula (I only have length and width measurements). Here is the
formula (4/3) x (Pi) x (W to the power of 2)/4) x (L/2). Seems simple except
for the squared part...any help would be much appreciated.

 

[Jeff Boyce]

Use the shift-6 symbol ("^") to represent raising a number to a power.

Or, since squaring is just multiplying a number by itself, put that
number/expression in twice, separated by a *. In your example, (W*W).

Regards

Jeff Boyce
Microsoft Office/Access MVP