J Jackske Registered User. Local time Today, 09:45 Joined Feb 28, 2000 Messages 48 Mar 10, 2004 #1 I want to change all names to vbpropercase via an update query. I did put the field "Names" in my query and wrote in update names:strconv(names,3). It does not work. Thanks in adavance, Jackse Belgium
I want to change all names to vbpropercase via an update query. I did put the field "Names" in my query and wrote in update names:strconv(names,3). It does not work. Thanks in adavance, Jackse Belgium
dcx693 Registered User. Local time Today, 02:45 Joined Apr 30, 2003 Messages 3,263 Mar 10, 2004 #2 I don't think you need: names:strconv(names,3) You need: StrConv(names,3) If that doesn't fix it, post your query SQL.
I don't think you need: names:strconv(names,3) You need: StrConv(names,3) If that doesn't fix it, post your query SQL.
J Jackske Registered User. Local time Today, 09:45 Joined Feb 28, 2000 Messages 48 Mar 11, 2004 #3 dcx693 said: I don't think you need: names:strconv(names,3) You need: StrConv(names,3) If that doesn't fix it, post your query SQL. Click to expand... I did not succeed. Look to the attachment. What is wrong? Jackske, Belgium Attachments query.gif 23.6 KB · Views: 190
dcx693 said: I don't think you need: names:strconv(names,3) You need: StrConv(names,3) If that doesn't fix it, post your query SQL. Click to expand... I did not succeed. Look to the attachment. What is wrong? Jackske, Belgium
J Jackske Registered User. Local time Today, 09:45 Joined Feb 28, 2000 Messages 48 Mar 11, 2004 #4 Jackske said: I did not succeed. Look to the attachment. What is wrong? Jackske, Belgium Click to expand... Here the correct attachmen. Attachments query.gif 28.5 KB · Views: 191
Jackske said: I did not succeed. Look to the attachment. What is wrong? Jackske, Belgium Click to expand... Here the correct attachmen.
