Access Database Program Help Needed.

Harritwo

Chief Petty Officer
Joined
Oct 4, 2011
Messages
586
I use Access in my business to create my quotes and invoice my products and services. I give a military discount to my customers that are active or retired. Is there any way to preload the discount into the database so that i can select a produst or service that says Mil Discount and automatically give the discount?:confused:
 

Alan_Scott

Seaman
Joined
Nov 25, 2011
Messages
69
Re: Access Database Program Help Needed.

I can't help with your question but I'd like to say thanks for helping out our "Armed Forces".
 

StickyWidget

Seaman
Joined
Aug 2, 2011
Messages
72
Re: Access Database Program Help Needed.

I can figure it out for you but it would be all but impossible to do with out the database file your using. Can you attach it in a PM?
 

Harritwo

Chief Petty Officer
Joined
Oct 4, 2011
Messages
586
Re: Access Database Program Help Needed.

I located a work around. Simply export the file to Excel, change the format in the cells to accept negative numbers and reimport it back into Access. It worked and I am happy. For anyone else that needs this solution, it was fairly simple once I played around with it, It took about an hour to sort it out.
 

colbyt

Master Chief Petty Officer
Joined
Aug 9, 2012
Messages
824
Re: Access Database Program Help Needed.

Access was my personal Waterloo. I should think there is a way on the report page to multiply the total by .90. I coulud probably do in MySql but not Access.

Actually the way I would do it in MySQL might work for you in the future. All you need is another field (column) say M_Price let the calculated value of that field be .90 (for a 10% discount) of the price field.
 
Top