Is there any way I can achieve this in MS Access? I tried this and it doesn't recognize charindex.

still the same error.

Operand data type nvarchar is invalid for sum operator.

I ran your code and I got this error.

Operand data type nvarchar is invalid for sum operator.

I am really sorry, its money datatype.

Preoverride, postoverride and shared dollar values will be like this $ 3, 456

Its numeric datatype

like this

'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)/12 as MONEY),1), '.00', '') as Monthly_Amount,

yes also for monthly_amount I need to have two decimal values

Like

$ 134,98.55

$ 41.34

No I don't get sum for 2 nd column

the datatypes are of decimal(10,4)

the datatype is decimal(10,4)

Current Value:

12,589.25

Expected Output:

12,589

Okay and Thanks:-)

yours worked too and I was asking whether mine is correct.

I tried this and what is your suggestion>?

<=DATEADD(yy,DATEDIFF(yy,0,getdate()) + 1,0)

Updated my post and pls take a look.

Can you show an example. I am bit confused how to apply this into my query.