If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using criteria
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 |
#2
|
|||
|
|||
Using criteria
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 Dave wrote: 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 |
#3
|
|||
|
|||
Using criteria
Do these rows relate to a single field?
If so, in query design:- Field: Left([yourfield],3) Criteria: ="Pro" Andrew L. "Dave" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|