ROUNDING

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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...
 
Back
Top