I am using access 2003.

rgxExtract() from
http://www.j.nurick.dial.pipex.com/Code/vbRegex/rgxExtract.htm#Code
has helped me solve a problem partially but if anyone can tell me how to get
rgxextract() to find in a text Field "this or that or the other"

heres whats going on; I am pasting information into a Field, and rgxextract
in a query looks through the data that can be in any order to find what I ask
it to.

However the data doesn't cooperate as easily. for example the pasted data
will read "a cute 3bdr house for rent" and the following will extract the
data of 3bdr for me...... rgxExtract([paste row]," 3bdr")...... Unfortunately
if the ad reads with a slight variation of "a cute 3 bd house for rent" or "
a cute 3 bed for rent"  or "a cute 2 bd house for rent" as you can see people
have a different way of describing the information regarding how many
bedrooms the house has.

 I tried variations of  rgxextract. for example I tried; rgxExtract([paste
row],"3bdr","2 bdr","3 bed","3 bd","3bd")

I did this in hopes that rgx would look for all of those values and bring
back which one it found.

If I can't do this then I will need to make several new Fields in the query
to represent every possibility, then make another Field that will put them
all together and show me the results.

BTW I am using query to do this operation because of my limited VBA
knowledge


Thank you, for your consideration, Dave