Access want a parameter value / SQL group by not working

[JoeRooney]

Hi,

I am new to SQL in Access and have the below query with somesql I am currently writing.

Table: SCF_Historical_DB
Field to sum: Premium_Records
Group By: Operation_Type

The below query sums the total but is not grouping by theoperation type. It is just giving a grand total.

The operation type contains New Business, Renewal orCancellation but when I run the query I get a enter parameter value dialog boxfor Premium_Records.Operation_Type

When I leave it blank and press ok I grand total under premium,what I would to achieve is a total for each operation type.


Can any one assist with how to achieve this?

Any help is greatly appreciated.

SELECTFormat(Sum(SCF_Historical_DB.Premium_Records),"Currency") AS Premium
FROM SCF_Historical_DB
GROUP BY Premium_Records.[Operation_Type];

Thanks

 

[gsbelbin]

Try the last line as GROUP BY SCF_Historical_DB.Operation_Type

 

[JoeRooney]

Perfect, thank you

Here is my final code for anyone else that might find ituseful

SELECT SCF_Historical_DB.Operation_Type, Format(Sum(SCF_Historical_DB.Premium_Records),"Currency")AS Premium

FROM SCF_Historical_DB

GROUP BY SCF_Historical_DB.Operation_Type

 

[gsbelbin]

You're welcome!