Build Fields in Reports

[AL]

Hello to all and group,

I'm trying to create a expression in a query that will extract records
with the letter "P" in the "9"th position of the field.

Then I need to create a report from this query with a field in it that
will show the results of the query.

Thanks in advance.

 

[Rick B]

mid([somefield],9,1) ="p"



Rick B

 

[Allen Browne]

Set the Criteria under this field to:
Like "????????P*"