Re: Running a Query to Obtain One of Multiple Values in a Field
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Fri, 06 Jul 2007 18:30:53 GMT
lah5240@xxxxxxxx wrote:
I have a contact database which includes a field for category to
organize the contacts into correct groups for an email list.
The problem I am having is that when I try to sort or query to pull up
a specific category is that the people who belong to more than one
category (for example in the field it would read BZ, DW or something
along those lines) and when I filter or query it will not include any
of the people that have these multiple values, it only returns people
with just that one cateogry grouping.
My question is whether or not there is a formula or notation I can use
so that it will pull up any field that contains BZ or DW, etc. so I
can get a complete return of everyone belonging to that group, even if
they belong to another one as well.
I've been scratching my head for days on this one so any ideas or help
would be much appreciated! Thanks! :)
One should never store more than one value in a field. You are experiencing one
of the reasons for that rule.
You should have another related table (one to many relationship).
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- Follow-Ups:
- Re: Running a Query to Obtain One of Multiple Values in a Field
- From: Lovelee7285
- Re: Running a Query to Obtain One of Multiple Values in a Field
- References:
- Prev by Date: Running a Query to Obtain One of Multiple Values in a Field
- Next by Date: Re: report returns Field ID instead of value
- Previous by thread: Running a Query to Obtain One of Multiple Values in a Field
- Next by thread: Re: Running a Query to Obtain One of Multiple Values in a Field
- Index(es):
Relevant Pages
|
