Urgent Help with calculations

[Irunit]

Hello guys,



This forum has been a life saver for me.
I have a question within query, let us say I have 2 customers, customer 1 and 2. Customer 1 bought 5 books of X and customer 2 bought 6 books of X now in my orders tables I have custId 1 and 2 and when I run query it shows product X twice one for cust 1 and second for cust 2. so it shows 5 and 6 quantity, how can I get the total of these?

Thank you

[Welshgasman]

Click the totals button and group by product with a sum of product in another column.

[Irunit]

hey thank you,

How do I do that, "sum of product in another column."?

[Welshgasman]

Just put product into another column in the query designer and use sum in the dropdown.

[Irunit]

hello it is not working. Let me ask the question in another way.

I have two customers who bought same product, one 5 and the second 6. how can I get the total if orders are in same table?

[Irunit]

I have created a quick mini example. as u see in my query, I see duplicate because I have two customers, my question is how to get the total? can u please add it in the database I sent, so I can learn.
This may be simple to you but I am new to access.

Thank you.test querry.zip

[mike60smart]

Hi
I find the easiest way to do this is in a Report

See the attached

[Irunit]

I see, thank you.

But I need in my report to see the total of all product regardless of customers.

How can I do that? (even if it is complicated)

[mike60smart]

Hi
Not following.
Your example database has a Total of 11 items Sold.

What else would you need to see in the Report?

[Irunit]

I want a way that says Total of Orders are 30 and total of sales are 11.

meant to say within the query field and not to press total and see SUM below. I need another field, right? but which calculation to write? (just thinking out loud)

[Irunit]

I see your point, and if the report is what I need, that is a new perfect way to do it.

Thx for that..

But what I need is like I said above, for those numbers to be within the query tables..

[mike60smart]

Hi

See the modified attached example

[Irunit]

Hi again, this is perfect.

Is there a way to have same results in a row next to the one who are already in that query?

[mike60smart]

Hi

Post a screenshot of what result you would like to see.

[Irunit]

Voila!