By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,479 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,479 IT Pros & Developers. It's quick & easy.

Filter Sort Wild Card?

P: n/a
MX1
Hi all,

I have a form with a dropdown field on it that is a concatenation of
LastName, FirstName and Middle Initial. For example, John A Brown shows up
as "Brown, John A." I'm tring to filter on this field to show me specific
records. However, it seems as though I have to type in the whole value for
it to find the record I'm looking for due to the concatenation. I was
hoping I could set this field to auto-fill in when I filter on it. For
example, I right click field and select filter sort. As soon as I start
typing B R O, it would come up with Brown, John A. If that is not possible,
is there some sort of wildcard I can use in my filter so it picks up the
value without me typing the whole concatenated value - (e.g Brow*, or
Brow%). I've tried lots of possible wildcards but none work.

Thanks in advance!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
MX1
Duh, got it...

"MX1" <mx*@mx1.abc> wrote in message
news:t_DDb.570102$Fm2.534891@attbi_s04...
Hi all,

I have a form with a dropdown field on it that is a concatenation of
LastName, FirstName and Middle Initial. For example, John A Brown shows up as "Brown, John A." I'm tring to filter on this field to show me specific
records. However, it seems as though I have to type in the whole value for it to find the record I'm looking for due to the concatenation. I was
hoping I could set this field to auto-fill in when I filter on it. For
example, I right click field and select filter sort. As soon as I start
typing B R O, it would come up with Brown, John A. If that is not possible, is there some sort of wildcard I can use in my filter so it picks up the
value without me typing the whole concatenated value - (e.g Brow*, or
Brow%). I've tried lots of possible wildcards but none work.

Thanks in advance!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.