'Discount' option as both £ and %

[AndyCabbages]

vbaInet, once again you have come to my rescue and provided excellent support, thank you very much

If your'e interested the Control Source for the total now looks like this:

=IIf([DiscountOption]=1,[SubTotal]*(1-([discount]/100))+[courier],[SubTotal]-[discount]+[Courier])

All thats left now is to impliment this piece of code in to all the reports that use the Total value.

 

[vbaInet]

Great work there AndyCabbages. I'm glad you got the concept. Good luck implement it on the rest of your db.

You're welcome.