you are a genius J Livingston SQL, square brackets worked. Thank you for your time.

If I change it gives me syntax error. I wondered if I need to use some kinde of brackets or comas before and after "Current"

you were right I missed commas, it has been fixed now and working perfectly thank you very much for your help.

Also how do I change Colum header name? For example...

thanks for your reply I get these error messages

1- incorrect syntax near the keyword'CASE'

2- incorrect syntax near the keyword'age31to60'

3- incorrect syntax near the keyword'age61to90'

I have put the formula...

This is my whole formula

SELECT Entities.Code, Entities.Name, Ac_Billbook.MatterRef, Ac_Billbook.BillDate, Ac_Billbook.Ref, Matters.FeeEarnerRef, Users.FullName, Ac_Billbook.OutstandingTotal, CaseTypes.CodeName, CaseTypes.Description,

CASE DATEDIFF(day, Ac_Billbook.BillDate, getdate()) Between 0 and 30 THEN Insert into (Ac_Billbook.OutstandingTotal) Value ('K')

CASE DATEDIFF(day,...