In a field I want to display a rounded up or down value that is the product of One field divided by another.

I do not see how to display the results field as a whole number or specify how many decimal places in the field.

WHere do I place the rounded function?

In Layout mode, select the field and choose Format > Number… > Format as decimal. This does not change the actual value, only the way it's displayed. To really round the result of the calculation, use:

Round ( Onefield / Anotherfield ; precision )

Thanks the display rounding works and thanks.

But I am not sure where to put the function you described so the data in the Avg Steps Min is a whole number.

Round ( Onefield / Anotherfield ; precision )

This is what I want a whole number rounded up or down called Avg Step per minute

Time in minutes is a numeric number (10.25, 10.5, 11)

Where do I place this rounding function? I put it after the field calculation function and got a - could not find this function type error message

NS Total Steps / NS TIme Minutes

Round ( NS Avg SPM ; precision )

What is precision a zero whole number or decimal places?

Using your syntax

Round (NS Total Steps / NS TIme Minutes ; zero

I get a specified field cannot be found message.

This seems like a lot of work for something so simple. THey make connecting relational databased sooooo simple yet the simple stuff so complex. GRR

I'm afraid I don't quite follow your description. If you have a calculation =

NS Total Steps / NS TIme Minutes

and you want the result to be rounded to the nearest integer, change the formula to:

Round ( NS Total Steps / NS TIme Minutes ; 0 )

I don't think it can be any simpler than that.