Make Calculations Based Data In Access 2010
In this article I am going to explain Make calculations based on our data In Access 2010.
Make calculations based on our data
-
Calculations value are based on change, because the value can become out of date in some cases.
-
For Example, when we create a employee table then we do not store age in a table, because every year we would have to update the value.
-
So we store the employee date of birth in our table, and then use an expression in a query to calculate the person's age.
Use the following procedure to create a query that calculates product subtotals based on data from order details table.
- First we open the northwind database in access 2010.
-
We click the create tab and then click the query design in a query group.
-
When open the show table, then double click the order details, on the table tab.
-
Then close the show table dialog box.
-
When we open the order table then double click product id.
-
Add a field to the first column of the query design grid.
-
In the second column of the grid, right-click the Field row, and then click Zoom on the shortcut menu.
-
Then type the code in the zoom table.
-
Subtotal: ([Quantity]*[Unit Price])-([Quantity]*[Unit Price]*[Discount]).
- Then we click run tab in result group and save the query, and then name the query Product Subtotals.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here