Convert query to access help

[Bell1991]

I have the following query:

Select
txtName ,
sum(numPrice) as numTotalPrice
from tblProducts
Group by txtName

The error i am getting is: You tried to execute a query that does not include the specified expresseion 'txtName' as part of an aggregate function. It works great in ms sql server..

Any suggestions?

Thanks

 

[Crowley16]

if you use a group, then you have to make sure every one of your fields is also within a group...

so, you need to add:

...group by txtName, sum(numPrice)

--------------------
Procrastinate Now!

 

[Crowley16]

Oops, a little amendment, the grouping require you to group every calculated expression you have selected...

--------------------
Procrastinate Now!

 

[Bell1991]

Thanks!