none
Calculate cost markup in Access form, query or table.

    Question

  • Hi,

    In an access form I would like the user to be able to enter cost in one field, the precentage markup in another field and have the total cost displayed in another field at runtime.

    Cost                Precent Markup                Total Cost

    $100.00              25                              $125.00

    What is the best way to do this in terms of field format for the various text box controls and the actual formula I would use?  I suppose the calculated value could be stored or not stored but I will have to merge the calculated figure into a Word document or Pdf later. 

    Thank you. 


    • Edited by Mark98765555 Wednesday, January 09, 2013 8:27 PM
    Wednesday, January 09, 2013 8:20 PM

Answers

  • Cost would be a Currency field and Percent Markup a Number (Integer) field.

    You can calculate Total Cost in a query based on the table:

    Total Cost: [Cost] * (1 + [Percent Markup]/100)

    Set the Format property of the Total Cost column to Currency.

    Use the query as data source for the mail merge in Word or for export to PDF.


    Regards, Hans Vogelaar

    • Marked as answer by Mark98765555 Wednesday, January 09, 2013 10:09 PM
    Wednesday, January 09, 2013 9:32 PM

All replies

  • Cost would be a Currency field and Percent Markup a Number (Integer) field.

    You can calculate Total Cost in a query based on the table:

    Total Cost: [Cost] * (1 + [Percent Markup]/100)

    Set the Format property of the Total Cost column to Currency.

    Use the query as data source for the mail merge in Word or for export to PDF.


    Regards, Hans Vogelaar

    • Marked as answer by Mark98765555 Wednesday, January 09, 2013 10:09 PM
    Wednesday, January 09, 2013 9:32 PM
  • Thank you. It works perfectly.
    Wednesday, January 09, 2013 10:11 PM