Hello,
I am having trouble getting the correct syntax to format a query field that is a calculation.
Please help!
This is my expression in my query field: the name of the field is 48 and the calculation is working correctly for me however there are like 10 decimal places and I want only 3.
48: ((36/48)*(([Yards]*36)*[Inches])/1296)
I have tried the following 2 ways below but still can’t get it into my query without a too many parenthesis error.
Format([48: ((36/48)*(([Yards]*36)*[Inches])/1296)], “0.000”)
48: Format(((36/48)*(([Yards]*36)*[Inches])/1296), “0.000”)
Thanks in advance for any assistance.
BJF
I am having trouble getting the correct syntax to format a query field that is a calculation.
Please help!
This is my expression in my query field: the name of the field is 48 and the calculation is working correctly for me however there are like 10 decimal places and I want only 3.
48: ((36/48)*(([Yards]*36)*[Inches])/1296)
I have tried the following 2 ways below but still can’t get it into my query without a too many parenthesis error.
Format([48: ((36/48)*(([Yards]*36)*[Inches])/1296)], “0.000”)
48: Format(((36/48)*(([Yards]*36)*[Inches])/1296), “0.000”)
Thanks in advance for any assistance.
BJF