Can the replace & StrConv be used together???

I have a query that returns JACK THE* RIPPER so I want to replace the * with " " & have it in lower case...

I have CUSTOMER: Replace([CUSTOMER_NAME],"*",StrConv([CUSTOMER_NAME],3," "))

I get an #Error in return...

don't know if I could even use them together... just testing things out. I know I can build another query using this query & just use the StrConv function then but rather do it in one if possible.

if you want lower case for all letters, try...
=LOWER(REPLACE(I16,FIND("*",I16,1),1," "))
Adjust references as needed
I am using 2007, and it doesnt have =strconv() function (have never heard of that either lol), if you want to have Upper Case For First Letters, change the =lower() to =proper()

Sorry, I thought this was an excel question

This worked for me.

Please Login or Register  to view this content.

Change up the table name and field name to suit your db.

Alan