Add a 1.5% charge to invoice?

[alx100]

Hi all,

I hope you guys can help me! I am a total noob on Access 2003.
I run a small car garage with a paper based filing system, but I decided a while back to start using a database.



Anway, I downloaded the excellent and free 'service management' template from the Microsoft Site:

http://office.microsoft.com/en-us/te...ai:TC001018467

I have amended some of the fields and text boxes to my needs.

Anyway, I have one big problem that I have no idea on how to sort.

If someone decides to pay their bill via credit card, I want the database to add a 1.5% charge (of the total bill) to the total bill, but I have no idea how I can do that.
I also need this charge to be shown on the invoice when printed (called 'Invoice' in the Reports Objects in the template database).

As I said, I am a total newbie on this, so dont even know if it is possible. The only things I have done to this database is just change some of the text boxes, so

nothing major.

Look forward to replies!

Thanks
Alex

[RuralGuy]

This is just my $0.02 but having accepted credit card payments for over 20 years, all you do is piss off the public. It is simply a cost of doing business. Better to increase your rates by 1% or 1.5% and let it go.