S srb3464 New member Local time Today, 06:31 Joined Feb 15, 2005 Messages 5 Feb 15, 2005 #1 Hi, can anyone tell me how to remove the first character of a field when viewing data in a querry. ie original data- V00366L2336 new data - 00366L2336
Hi, can anyone tell me how to remove the first character of a field when viewing data in a querry. ie original data- V00366L2336 new data - 00366L2336
L llkhoutx Registered User. Local time Today, 00:31 Joined Feb 26, 2001 Messages 4,018 Feb 15, 2005 #2 right([YourData],len([YourData]-)
S srb3464 New member Local time Today, 06:31 Joined Feb 15, 2005 Messages 5 Feb 15, 2005 #3 Not working Just tried it and does not seem to work perhaps you could tell me the complete syntax. the field of the original data is PartNumber and the data is in different lenghts the new field needs to be called new thanks
Not working Just tried it and does not seem to work perhaps you could tell me the complete syntax. the field of the original data is PartNumber and the data is in different lenghts the new field needs to be called new thanks
L llkhoutx Registered User. Local time Today, 00:31 Joined Feb 26, 2001 Messages 4,018 Feb 15, 2005 #4 In the QBE field: NewName:Right([YourData],len([YourData])-1) I apologize for the typo.
