Using criteria

[Dave]

I have a query with the following rows:

Pro1
Pro2
Pro3
Pro4
abc1
abc2
abc3

etc.

Is there any way to make a selection that just returns the Pro1, 2,3,4
rows - I thought of perhaps using Like, but cant seem to make it work

 

[John Spencer (MVP)]

It always helps if you show what you tried. AND explain why the results weren't
what you wanted - too many records, wrong records, no records, an error message.

Did you try criteria of

LIKE "PRO*"

or

LIKE "PRO%"

IF so, what results did you get and why weren't they appropriate

 

[Andrew L.]

Do these rows relate to a single field?

If so, in query design:-

Field: Left([yourfield],3)

Criteria: ="Pro"

Andrew L.