Microsoft access and markup percentage

I am using Microsoft Access I am trying to create a percentage column by using the expression builder. I want the field to be a percentage in terms of a value in the previous column divided by the total of that column. Any assistance will be much appreciated. If you use the sum construct then it will only allow you to have a single column in your query. You may have to provide a function to do it.

Define a function that returns the sum of a particular column. Then define a query that utilises that function in order to calculate the percentage. Percentages for data in a record is easily done. A more challenging request is Percent of Total. That can also be done. This can be easily done without any VBA code. Luke is absolutely right about the Percent of Total calculation. Follow that link in the post above.

Thank you all so much for the assistance Martin, Luke, Marvin. It worked perfectly well. No Account? Thus, Microsoft Access Invoicing software is mainly optimized for small businesses.

So, if you need to use it, develop it for your own business, or for the purpose of learning, then you can surely depend on it since all VBA codes are visible for you. In fact, it has the main tools that every small business needs such as billing, invoicing, managing the inventory, expenses, users and many more.

Above all, the main features of Microsoft Access Invoicing software are:. It provides the current user with the total sales for a specific period. In addition, It provides a printable report upon request. The report shows the user activity in details. It enables the current user to prepare and manage the orders of his customer and save it. Once the order is ready, the user can issue the invoice and it will be automatically transferred to the invoices page with a unique reference number and deducts the purchased items from the inventory.

It shows all issued invoices. Moreover, this page will give you the ability to find and browse invoices easily. In addition, invoices page is supported with a refund tool. So, the customer can refund a part of his purchases or even the entire invoice depending on the administrator privileges. The inventory page shows all available items in details.

So, the user can update the inventory if needed. In addition, the admin user can check any selected item and register it in order to request it from his registered supplier. Quick access. Search related threads. Remove From My Forums. Answered by:.

Archived Forums. This IT Professional forum is for general questions, feedback, or anything else related to Office Sign in to vote.