query that reads only part of a field

  • Thread starter Thread starter Jeff Brooks
  • Start date Start date
J

Jeff Brooks

I am trying to run a query that will read only up to a certian point of the
record in a field.

I have a field which contains a varying amount of numbers and letters. I
want to read everything prior to a specific instance of letters.

for instance, I could have the following records in my field:
7t3VkHHHH003
8np6HHHH5
5ebgihan44HHHH98

and in my query, I only want to read the text to the left of "HHHH".

Thanks,
Jeff
 
Jeff Brooks said:
I am trying to run a query that will read only up to a certian point of the
record in a field.

I have a field which contains a varying amount of numbers and letters. I
want to read everything prior to a specific instance of letters.

for instance, I could have the following records in my field:
7t3VkHHHH003
8np6HHHH5
5ebgihan44HHHH98

and in my query, I only want to read the text to the left of "HHHH".
Click to expand...

NewField: Left([OldField], Instr(1, [OldField], "HHHH")-1)
 
Back
Top