calculated fields need help?

[Roger]

I am looking for some help with my calculations. I am un sure on where the curly brackets go, or do I need quotation marks.

I can do the calculation in excel 2010 but not in access 2010. I am using this in a table not a query.

[runs]/[innings]-no]

Many thanks in advance Roger

[JoeM]

Access 2010 introduced new functionality that allows you to do calculations in a Table. That doesn't mean that is how you should do it.
No other database programs allow this. Where this can be an issue is if you ever need to convert it to another program (like SQL or Oracle).
The general rule of thumb with relational databases is that all calculations should be done in queries.

That being said, the logic is the same. Is "no" a field? Then maybe your calc should look like:
[runs]/([innings]-[no])
Of course, I am just guessing at the logic behind the formula (you haven't told us what the formula is supposed to do).