Can this be done? I have a certain company that has many
locations, and the location is at the tail end of the name.
I need to find all companies that begin with the word
"Budget" for one of my select case statements. "Budget*" or
"Budget"* doesn't work.

The statement, FYI, is:
Case "Budget*", "OPSM", "Precision"
isGroup = "OPSM"

Rose,

This is not possible with the select-case construct, but you could use an if
statement:

If company Like "Budget*" Then


"Rose" <(E-Mail Removed)> wrote in message
news:1163601c4419d$3c90ccd0$(E-Mail Removed)...
> Can this be done? I have a certain company that has many
> locations, and the location is at the tail end of the name.
> I need to find all companies that begin with the word
> "Budget" for one of my select case statements. "Budget*" or
> "Budget"* doesn't work.
>
> The statement, FYI, is:
> Case "Budget*", "OPSM", "Precision"
> isGroup = "OPSM"
>

Crap. I need to use Select because I actually have about 15
companies I'm herding off to their own particular groups,
and that's too long for an If. (I only quoted part of the
whole function in my example.)

Are my only other solutions to either change my data, run
another layer of query to effectively change my data, or
have an incredibly long (and regularly updated) Select
statement?

>-----Original Message-----
>Rose,
>
>This is not possible with the select-case construct, but
you could use an if
>statement:
>
>If company Like "Budget*" Then
>
>
>"Rose" <(E-Mail Removed)> wrote in message
>news:1163601c4419d$3c90ccd0$(E-Mail Removed)...
>> Can this be done? I have a certain company that has many
>> locations, and the location is at the tail end of the name.
>> I need to find all companies that begin with the word
>> "Budget" for one of my select case statements. "Budget*" or
>> "Budget"* doesn't work.
>>
>> The statement, FYI, is:
>> Case "Budget*", "OPSM", "Precision"
>> isGroup = "OPSM"
>>
>
>
>.
>

You can specify a range in a Case.

Since the wildcard is the trailing character, this should work:

Case "Budget" to "Budgetzzzzzzzzz", "OPSM", "Precision"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rose" <(E-Mail Removed)> wrote in message
news:1163601c4419d$3c90ccd0$(E-Mail Removed)...
> Can this be done? I have a certain company that has many
> locations, and the location is at the tail end of the name.
> I need to find all companies that begin with the word
> "Budget" for one of my select case statements. "Budget*" or
> "Budget"* doesn't work.
>
> The statement, FYI, is:
> Case "Budget*", "OPSM", "Precision"
> isGroup = "OPSM"

Rose,

Can you provide all of your examples I am not sure I follow exactly what you
want to do?
For instance you stated that the location name is always at the end of the
company name so why not look at it from that prespective and combine it with
your select case statement for instance:

If companyname LIKE "*OPSM" Then
IsGroup = "OPSM"
Else If companyName Like "*XXX" Then
IsGroup = "XXX"
Else If ...

Else
Select Case companyName
Case "Percision"
Case ...
End Select
End If

You could as you suggested create another table that relates the company to
a group such as:

CompanyID, GroupID


Regards,
Dan

"Rose" <(E-Mail Removed)> wrote in message
news:115a601c441a0$eb405090$(E-Mail Removed)...
> Crap. I need to use Select because I actually have about 15
> companies I'm herding off to their own particular groups,
> and that's too long for an If. (I only quoted part of the
> whole function in my example.)
>
> Are my only other solutions to either change my data, run
> another layer of query to effectively change my data, or
> have an incredibly long (and regularly updated) Select
> statement?
>
> >-----Original Message-----
> >Rose,
> >
> >This is not possible with the select-case construct, but
> you could use an if
> >statement:
> >
> >If company Like "Budget*" Then
> >
> >
> >"Rose" <(E-Mail Removed)> wrote in message
> >news:1163601c4419d$3c90ccd0$(E-Mail Removed)...
> >> Can this be done? I have a certain company that has many
> >> locations, and the location is at the tail end of the name.
> >> I need to find all companies that begin with the word
> >> "Budget" for one of my select case statements. "Budget*" or
> >> "Budget"* doesn't work.
> >>
> >> The statement, FYI, is:
> >> Case "Budget*", "OPSM", "Precision"
> >> isGroup = "OPSM"
> >>
> >
> >
> >.
> >

Perfect - thanks!!

>-----Original Message-----
>You can specify a range in a Case.
>
>Since the wildcard is the trailing character, this should
work:
>
>Case "Budget" to "Budgetzzzzzzzzz", "OPSM", "Precision"
>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>
>"Rose" <(E-Mail Removed)> wrote in message
>news:1163601c4419d$3c90ccd0$(E-Mail Removed)...
>> Can this be done? I have a certain company that has many
>> locations, and the location is at the tail end of the name.
>> I need to find all companies that begin with the word
>> "Budget" for one of my select case statements. "Budget*" or
>> "Budget"* doesn't work.
>>
>> The statement, FYI, is:
>> Case "Budget*", "OPSM", "Precision"
>> isGroup = "OPSM"
>
>
>.
>