Thank you so much Eric,
I have to apologize, I made a mistake in the DB were I had a space in the row name causing the SQL error. having looked at something for so long I forget to always look at the simplest explanation.
Thank you for the help with how to change the currency. Everything is working well.
Best Wishes and again thank you for your support.