I am finishing up an assignment in Microsoft Access and am having trouble understanding how to make this formula. The question states to write a query that shows each customer (Id, first and last name) along with the total amount of revenue for each customer (revenue=quantity*cost). I am able to get the tables I need listed, but I am at a loss as to how to calculate this revenue problem so that Access will understand what I am asking.
Any help you can provide would be aprreciated.
Thanks
I know absolutely nothing about Access. It's all I can do to make formulas work in Excel!
But I do know one thing ... when I really need to know something specific, I can go to http://www.microsoft.com and click on Support at the right, and then go into the Knowledge Base for specific help.
If you have Office (or Access) 2003 or later, you can also get online help simply by pressing the F1 key and typing in your query.
Good luck.
=)
I understand that you are having trouble creating a formula in Microsoft Access to calculate the revenue for each customer. Here's a step-by-step guide to help you with that:
1. Open Microsoft Access and open the database that contains your tables.
2. Click on the "Queries" tab in the ribbon and select "New" to create a new query.
3. In the query design window, add the customer table to the design grid by dragging it from the list of tables.
4. Select the fields you want to include in the query, which are the customer ID, first name, and last name. You can do this by double-clicking on each field or dragging them to the query design grid.
5. To calculate the revenue for each customer, you need to create a new field in the query that calculates the product of the quantity and cost fields. To do this, right-click on an empty cell in the query design grid and select "Build..."
6. In the Expression Builder window that opens, you can create your formula. The revenue formula is revenue = quantity * cost. To build this formula, select the "Functions" tab and expand the "Math" category. Double-click on the "Multiply" function to add it to the expression.
7. In the Expression Builder, double-click on the quantity field to add it to the formula, followed by the multiply operator (*), and then double-click on the cost field to add it as well. Your formula should now look like "[quantity] * [cost]".
8. Click "OK" to close the Expression Builder and return to the query design grid.
9. Your revenue field should now be added to the query design grid. You can give it a meaningful name by typing it into the "Alias" column, such as "Total Revenue". This name will be displayed as the column heading in the query results.
10. Save the query by clicking on the "Save" button in the ribbon and giving it a name.
11. To view the results, click on the "Datasheet View" button in the ribbon.
I hope this step-by-step guide helps you create the formula to calculate the revenue for each customer in Microsoft Access. If you have any further questions or need additional assistance, feel free to ask.