Hi all, I am new to this forum and have not really designed any advanced databases. I am trying to designa database for our local minor softball league and am having troubles getting a calculation in a query to work right. I have a number of field such as;

H (hits) BB (balls on base) AB (at bats) HBP (hit by pitch)
33 12 62 0

First I am trying to add H + BB + HBP together then devide by AB + BB + HBP

Here is what I came up with;
OBP: Sum(([Batting]![H])+([Batting]![BB])+([Batting]![HBP]))/(([AB])+([Batting]![BB])+([Batting]![HBP]))

I am guessing the problem is with the "[" or "("

Sure would appreciate it if you could help...thanks.

If you are only taking this data from one table (Batting) then you don't need to state that in your report. I am assuiming it is a control in a report. Perhaps a query. I would use a query and pass that to the report.

OBP:(([H]+[BB]+[HBP])/([AB]+[BB]+[HPB]))

This should work. This also assumes that your table fields are all number fields (integer, long, etc.)

HTH

mmcdonal

Thanks, my mistake was even though I just had numbers in all the fields, I had them as text fields, when i switched to number fields it worked fine. Cheers.

Another question if I may, could you please tell me the imput mask to use in order not to show a zero in from of a decimal Ex. I want 0.654 to show as .654
Thanks again