CCur function

[user18]

Im summarizing data with criteria and its asking me to use the Ccur function. The line is the query is
TotalSales: Sum(CCur([tblOrderDetails!Quantity]*[tblProducts!Price])), it wants me to take out the sum function, and put where in the Totals drop-down list. When I do this it gives me an error message. Why wont it work?

 

[giacomo]

What error message are you getting?

 

[mdmilner]

Looks like a syntax error to me.
SUM is an Excel function - it is not needed within SQL.

It should work if you strip it down to:

TotalSales: CCur([tblOrderDetails!Quantity]*[tblProducts!Price])

You can also look at your syntax for reference to specific fields.
When you run the wizard, it prefers brackets around tables & fields like:

TotalSales: CCur([tblOrderDetails].[Quantity]*[tblProducts].[Price])

Mike