CloseTo What I need!

  • Thread starter Thread starter Ady
  • Start date Start date
A

Ady

Hi There

Many thanks for your reply! However it is not quite working as I
anticipated!!! Let me explain better!

My SUM adds up all the order lines and then produces a total. For example:

Part A: £10
Part B: £15
Part C: £12
Total: £37

I then requested help because if the Total was less than £10 it would
display £10. However the problem is that it now rounds up to £10 on every
order line! I only want the SUM total to round up to £10.

How it works now:
Part A: £5 (It thinks this is £10!!!!!)
Part B: £15
Part C: £12
Total: £37

How I need it to work:
Part A: £2.50
Part B: £2
Part C: £2
Total: £10

Sorry to be awkward. Many many many thanks for any help and advice given!

Regards

Ady







Fons Ponsioen said:
You could do this with
=Sum(IIF([ViewedItemTotal]<10,10,[ViewedItemTotal]))
Hope this helps.
Fons
-----Original Message-----
Hi There

I have a formula in my report that adds up all the values of each order:
=Sum([ViewedItemTotal])

However I need a cleverer formula than this! I need a formula that will do
the above, but if the total value of the order is less than 10 it needs to
round up to 10. For example if the total order is 7.50 the field needs to
display 10.

Any help would be highly appreciated.

Regards

Ady


.
Click to expand...
Click to expand...
 
Ady,

Try it like this...
=IIf(Sum([ViewedItemTotal])<10,10,Sum([ViewedItemTotal]))
 
Hi There

Many thanks for your reply. It worked!

Ady

Steve Schapel said:
Ady,

Try it like this...
=IIf(Sum([ViewedItemTotal])<10,10,Sum([ViewedItemTotal]))

--
Steve Schapel, Microsoft Access MVP

Hi There

Many thanks for your reply! However it is not quite working as I
anticipated!!! Let me explain better!

My SUM adds up all the order lines and then produces a total. For example:

Part A: £10
Part B: £15
Part C: £12
Total: £37

I then requested help because if the Total was less than £10 it would
display £10. However the problem is that it now rounds up to £10 on every
order line! I only want the SUM total to round up to £10.

How it works now:
Part A: £5 (It thinks this is £10!!!!!)
Part B: £15
Part C: £12
Total: £37

How I need it to work:
Part A: £2.50
Part B: £2
Part C: £2
Total: £10

Sorry to be awkward. Many many many thanks for any help and advice given!

Regards

Ady
Click to expand...
Click to expand...
 
Back
Top