New Table Query?

[JT]

Hello helpful community,
In Excel you can pull specific data from a record using
the mid formula [example =MID(A2,3,1)], which would yield
the third character in the cell. What is the similar
expression in Access? I have a table in access called
MOVIES, which contains TITLES and IDNUM fields. I want to
extract each individual character from the IDNUM field in
the MOVIES table and create a new table with the data. I
want to call the new table JACKETLABLE and have it contain
the fields from the MOVIE table plus, P1, P2, P3, P4, P5,
P6, P7, where P1-P7 (P=position's) contain the individual
characters from the 7 character IDNUM field.
Thanks in advance for you assistance.
JT

 

[Gerald Stanley]

The function is the same in Access.

Hope This Helps
Gerald Stanley MCSD