J jkpats12 Registered User. Local time Today, 21:39 Joined Jan 27, 2004 Messages 45 Jan 5, 2007 #1 Hello, Is it possible to remove a couple of numbers in the middle of a field by using an update query ? I have for example: YF000491 and would like to make it YF0491. Any help would be greatly appreciated. Thanks
Hello, Is it possible to remove a couple of numbers in the middle of a field by using an update query ? I have for example: YF000491 and would like to make it YF0491. Any help would be greatly appreciated. Thanks
KeithG AWF VIP Local time Today, 13:39 Joined Mar 23, 2006 Messages 2,592 Jan 5, 2007 #2 Yes it is possible with the Right,Left, and/or Mid functions.
J jkpats12 Registered User. Local time Today, 21:39 Joined Jan 27, 2004 Messages 45 Jan 5, 2007 #3 Thansk for the reponse Keith, but I'm not too familiar on creating those....would anyone happen to have an example ? Thanks
Thansk for the reponse Keith, but I'm not too familiar on creating those....would anyone happen to have an example ? Thanks
J jkpats12 Registered User. Local time Today, 21:39 Joined Jan 27, 2004 Messages 45 Jan 5, 2007 #4 That is correct Bob
J jkpats12 Registered User. Local time Today, 21:39 Joined Jan 27, 2004 Messages 45 Jan 5, 2007 #5 Bob thank you very much this worked perfectly.
S sharzi New member Local time Today, 13:39 Joined Nov 13, 2017 Messages 4 Nov 13, 2017 #6 Can someone tell me if we have some condition that we don't want to apply left or right to those conditions then what we should do?
Can someone tell me if we have some condition that we don't want to apply left or right to those conditions then what we should do?
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 04:39 Joined May 7, 2009 Messages 20,516 Nov 13, 2017 #7 if the condition is simple. you can use sing Left, Right, Mid. if more complex that the query cannot evaluate it, use Function.
if the condition is simple. you can use sing Left, Right, Mid. if more complex that the query cannot evaluate it, use Function.
S sharzi New member Local time Today, 13:39 Joined Nov 13, 2017 Messages 4 Nov 13, 2017 #8 arnelgp said: if the condition is simple. you can use sing Left, Right, Mid. if more complex that the query cannot evaluate it, use Function. Click to expand... How to use function?
arnelgp said: if the condition is simple. you can use sing Left, Right, Mid. if more complex that the query cannot evaluate it, use Function. Click to expand... How to use function?