posted by Justin

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.


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 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.


Respond to this Question

First Name

Your Answer

Similar Questions

  1. spelling

    My class needs to write a report that starts with: I had trouble finishing the assignment because___. I always turn in my assignments in time, so I don't know what to write.
  2. Technical writing

    Access the user manual for any one of the following programs or applications: • Microsoft® Access • Microsoft® PowerPoint® • Microsoft® Excel • Microsoft® Word • Microsoft® Outlook® User manuals are available via the …
  3. Psychology

    I am having trouble understanding the following question: What prevents an individual from allocating attention the way in which they intend?
  4. computer science

    write a program that calculates a customer's monthly bill. it should input customer name, which package the customer has purchased, and how many hours were used. it should then create a bill that includes the input informtion and the …
  5. programing

    3.Write a query to display the annual salary of all employees in department_id 20. Display the names in increasing order or salary. 4.Write a query to display the average salary of employees. Label the column as ' Average Salary. 5.Write …
  6. programing

    5.Write a query to display the details of employees in the shipping' department who were hired after '01-JAN 1990' note that the query must use a join. 6.Write a query to display all unique department_id's in the employees table. 7.Write …
  7. Math

    f(x)=3x^2-x-2 If x=2, what is f(x)? What point is on the graph of f?
  8. political theory

    I don't have an assignment due, but I'm having trouble understanding the themes that are in the Persian Letters by Montesquieu. Has anyone read them?
  9. computer science

    An Internet service provider has three different subscription packages for its customers: Package A: For $9.95 per month 10 hours of access are provided. Additional hours are $2.00 per hour. Package B: For $13.95 per month 20 hours …
  10. Ed Tech plz helppppp

    What does it mean to troubleshoot your computer?

More Similar Questions