Get percentage over total

[franciscov]

Hi friends, I'm debutting on this forum to solve one question,

I have an Access table with many orders, each one with his price
In a query, I'd like to get the percentage of each price respect the amount of prices of all the records.
I'm using this expression.

Expr1: ([Price]*100) / Sum([Orders]![Price])

And I get the error
Your query does not include the specified expression "Expr1: ([Price]*100) / Sum([Orders]![Price])" as part of an aggregate function.

Any one does know If I can do this in access (In the same query, work with table amounts), and how to do it?
This is the SQL code
SELECT Sum(([Orders]*100)/Sum([Orders]![Price])) AS Expr1
FROM Table;
Thanks in advance

[Micron]

Use sigma icon on ribbon ( Σ ) to change query design to a Totals query. You could research ms access totals query if you need guidance.
Note - too many fields in a totals query might cause too many groups.

[franciscov]

Use sigma icon on ribbon ( Σ ) to change query design to a Totals query. You could research ms access totals query if you need guidance.
Note - too many fields in a totals query might cause too many groups.

The totals query calculates totals over all records, and that's not what I need.

Anyone knows if there's a way to get it?

[Micron]

It only does that if you don't apply criteria.

[CJ_London]

you can't combine a sum with a field value in the same query calculation which is why you get your error. Think you need to use a subquery to get the sum. Not clear what you are actually wanting from your sql or description but perhaps something like this air code will show you the way

SELECT Price, Round([price]*100/(select Sum([Price]) from Table AS S),2) AS pCent
FROM Table;

for the future, strongly advise provide some example data and the result required from that data - paints a much easier picture to understand rather than a written description

[Welshgasman]

The totals query calculates totals over all records, and that's not what I need.

Anyone knows if there's a way to get it?

Hmm, very dismissive response ?

[franciscov]

you can't combine a sum with a field value in the same query calculation which is why you get your error. Think you need to use a subquery to get the sum. Not clear what you are actually wanting from your sql or description but perhaps something like this air code will show you the way

SELECT Price, Round([price]*100/(select Sum([Price]) from Table AS S),2) AS pCent
FROM Table;

for the future, strongly advise provide some example data and the result required from that data - paints a much easier picture to understand rather than a written description

Thank you very much.

[franciscov]

Hmm, very dismissive response ?

Sorry about that, it was not my purpose.