Search code examples
ms-accessms-access-2016

Microsoft Access database table with percentage sum

Hi I have a total sum let say $100 and I want a new column to return 20% of (user input) which let say for example is $100 20% of $100 is $20 (so the table displays $20) how would I do that in a data table with expression builder? Help would be much appreciated! Thanks

(Sorry the first time I asked this I was a little to broad)

Solution

  • Use the expression:

    =0.2*[TotalSum]

    Then apply the format: Currency

    But do that either in a query or as the ControlSource for a textbox in your form, not in the table; tables are not for this.