G Guest Jan 30, 2006 #1 I need to create a query that removes the last 4-digits code on a field. Please help.
R Rick B Jan 30, 2006 #2 Is your field a set number of digits? If so use an update field and just update it to the left XX digits. If the format is variable, it is still possible, but you have to grab the number of digits, subtract four, and then grab those. =Left([somefieldname],10) would give you the left 10 digits.
Is your field a set number of digits? If so use an update field and just update it to the left XX digits. If the format is variable, it is still possible, but you have to grab the number of digits, subtract four, and then grab those. =Left([somefieldname],10) would give you the left 10 digits.
F fredg Jan 30, 2006 #3 I need to create a query that removes the last 4-digits code on a field. Please help. Click to expand... NewData:Left([OldData],Len([OldData])-4)
I need to create a query that removes the last 4-digits code on a field. Please help. Click to expand... NewData:Left([OldData],Len([OldData])-4)
