🚀 go-pugleaf

Use function LEFT() which:

Extract part of existing text values using a calculated field

1 In query Design view, create a query. Add the tables whose records you
want to use.
2 To find values in part of a field, use the Left, Right, or Mid function in
an expression in an empty cell in the Field row in the query design grid.

The syntax for these functions is:

Left(stringexpr,n)
Right(stringexpr,n)
Mid(stringexpr,start,n)

The stringexpr argument can be either a field name (enclosed in brackets) or
a text expression; n is the number of characters you want to extract; start
is the position of the first character you want to extract.

The following table shows examples of these functions.

If the value in
Part ID is                 This expression           Returns
BA-7893-R12         Left([PartID],2)             BA
BA-7893-R12         Right([PartID],3)           R12
BA-7893-R12         Mid([PartID],4,4)         7893

reards
asif