ROUNDING

N

Nanette

I'm tried using the following in a report:

Round(([TULCBBS]+[TFLCBBS)][,1])

=Round(([TULCBBS]+[TFLCBBS)][,1])

Round([TULCBBS]+[TFLCBBS][,1])

as well as many other renditions.

I'm trying to add two fields and then round them.
What is the correct syntax for this?
 
D

Damian S

Hi Nanette,

You need to get rid of the square brackets around the , 1, and swap the
parenthesis and square bracket beside TFLCBBS like this:

round(([TULCBBS]+[TFLCBBS]),1)

Damian.
 
N

Nanette

Thanks Damian,

I actually used Access's help to get the [,1]. Sometimes the Access help is
far from correct!

Damian S said:
Hi Nanette,

You need to get rid of the square brackets around the , 1, and swap the
parenthesis and square bracket beside TFLCBBS like this:

round(([TULCBBS]+[TFLCBBS]),1)

Damian.

Nanette said:
I'm tried using the following in a report:

Round(([TULCBBS]+[TFLCBBS)][,1])

=Round(([TULCBBS]+[TFLCBBS)][,1])

Round([TULCBBS]+[TFLCBBS][,1])

as well as many other renditions.

I'm trying to add two fields and then round them.
What is the correct syntax for this?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total is off by a couple of cents 4
adding a forumla to cells with formula in them already 1
Round up or down to nearest 5, but not 10 2
Rounding anomoly 2
Rounding and Displaying as Text 1
rounding a number up to a certain ending digit 6
round up to the next 1/2 kg....formatting 0
Formula to round based on thousandths place 4

Top