Using criteria

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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
 
Do these rows relate to a single field?

If so, in query design:-

Field: Left([yourfield],3)

Criteria: ="Pro"

Andrew L.
 
Back
Top