ignore char in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, i hope someone could help me with this....

i have a table....with model numbers and i want to break each model number
in a query.

model number # A331500M

I want my query to return A1500 ONLY...it's there a way to make this happen?
 
If all the fields have the same structure, you can try

Left([FieldName],1) & Mid([FieldName],4,4)
 
Will said:
Hello, i hope someone could help me with this....

i have a table....with model numbers and i want to break each model number
in a query.

model number # A331500M

I want my query to return A1500 ONLY...it's there a way to make this happen?
Click to expand...


If that example represents a parsing rule, then use a
calculated field with an expression like:

Left(model, 1) & Mid(model, 4, 4)
 
Back
Top