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...
 
You must log in or register to reply here.

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
Run report on the 5th of every month automatically 0
Arch Wins 10
Possible router problems 9
Rounding Up To Even number 1
Always round up in calculation 2
Rounding problem 2
How can I round a number to 2 significant figures 2

Back
Top