Help dividing two fields in a query

[aronnov]

how can i create a custom field in a query to take the sum of column a which is named 'H' and divide it by the sum of column b which is 'AB'? I already have the two columns summing. I just need help on how to create a custom field which i have no idea how to do and the syntax for the formula "column H/ column AB"

[aronnov]

alright. I have answered all my questions except one now.

is there a way to convert any number that ends in .333, .667, and .999 using an expression in a query?

the idea is to convert any number ending in .333 to .1, .667 to .2, and .999 to 1.0

[okerix]

Use a Switch in your expression like this:

Switch([Field]=.333,.1,[Field]=.667,.2,[Field]=.999,1.0)