Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple like statements?
Hello,
Is it possible to use more than one LIKE statment in an Excel Macro? Here is what I have: WHERE CAR.FAC_NO = HEAD.FAC_NO AND ((BALANCE.COMP='NIL') AND (BALANCE.YEAR=2005) AND (BALANCE.PER_NO=99) AND (BALANCE.ACCOUNT Like '5%') AND (HEAD.AREA like '333%')) Which works... But, I want to add more LIKE statments. i.e. ....AND (HEAD.AREA like '666%') AND (HEAD.AREA like '999%')) How ever I get errored out. The LIKE statements grabs groups of number with a common beginning three digits. But it seems I can only do it for only one set, number multiple numbers. Any suggestions? Tmuld |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple like statements?
Hi T,
Sub TestIt() If CAR.FAC_NO = HEAD.FAC_NO Then If BALANCE.COMP = "NIL" Then If BALANCE.Year = 2005 Then If BALANCE.PER_NO = 99 Then If BALANCE.ACCOUNT Like "5%" Then If HEAD.AREA Like "333%" Then If HEAD.AREA Like "666%" Then If HEAD.AREA Like "999%" Then 'Your result code here End If End If End If End If End If End If End If End If End Sub Note, all single quotes changed to double quotes. --- Regards, Norman wrote in message ups.com... Hello, Is it possible to use more than one LIKE statment in an Excel Macro? Here is what I have: WHERE CAR.FAC_NO = HEAD.FAC_NO AND ((BALANCE.COMP='NIL') AND (BALANCE.YEAR=2005) AND (BALANCE.PER_NO=99) AND (BALANCE.ACCOUNT Like '5%') AND (HEAD.AREA like '333%')) Which works... But, I want to add more LIKE statments. i.e. ....AND (HEAD.AREA like '666%') AND (HEAD.AREA like '999%')) How ever I get errored out. The LIKE statements grabs groups of number with a common beginning three digits. But it seems I can only do it for only one set, number multiple numbers. Any suggestions? Tmuld |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple like statements?
A number can't be like 666% and like 333%
Pehaps you wanted to use OR ? WHERE CAR.FAC_NO = HEAD.FAC_NO AND BALANCE.COMP='NIL' AND BALANCE.YEAR=2005 AND BALANCE.PER_NO=99 AND BALANCE.ACCOUNT Like '5%' AND (HEAD.AREA like '333%' OR HEAD.AREA like '666%')) Tim wrote in message ups.com... Hello, Is it possible to use more than one LIKE statment in an Excel Macro? Here is what I have: WHERE CAR.FAC_NO = HEAD.FAC_NO AND ((BALANCE.COMP='NIL') AND (BALANCE.YEAR=2005) AND (BALANCE.PER_NO=99) AND (BALANCE.ACCOUNT Like '5%') AND (HEAD.AREA like '333%')) Which works... But, I want to add more LIKE statments. i.e. ....AND (HEAD.AREA like '666%') AND (HEAD.AREA like '999%')) How ever I get errored out. The LIKE statements grabs groups of number with a common beginning three digits. But it seems I can only do it for only one set, number multiple numbers. Any suggestions? Tmuld |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple like statements?
Norman,
Looked like SQL to me.... Tim "Norman Jones" wrote in message ... Hi T, Sub TestIt() If CAR.FAC_NO = HEAD.FAC_NO Then If BALANCE.COMP = "NIL" Then If BALANCE.Year = 2005 Then If BALANCE.PER_NO = 99 Then If BALANCE.ACCOUNT Like "5%" Then If HEAD.AREA Like "333%" Then If HEAD.AREA Like "666%" Then If HEAD.AREA Like "999%" Then 'Your result code here End If End If End If End If End If End If End If End If End Sub Note, all single quotes changed to double quotes. --- Regards, Norman wrote in message ups.com... Hello, Is it possible to use more than one LIKE statment in an Excel Macro? Here is what I have: WHERE CAR.FAC_NO = HEAD.FAC_NO AND ((BALANCE.COMP='NIL') AND (BALANCE.YEAR=2005) AND (BALANCE.PER_NO=99) AND (BALANCE.ACCOUNT Like '5%') AND (HEAD.AREA like '333%')) Which works... But, I want to add more LIKE statments. i.e. ....AND (HEAD.AREA like '666%') AND (HEAD.AREA like '999%')) How ever I get errored out. The LIKE statements grabs groups of number with a common beginning three digits. But it seems I can only do it for only one set, number multiple numbers. Any suggestions? Tmuld |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple like statements?
Hi Tim,
Yes, the initial WHERE should have alerted me. Thank yoiu. --- Regards, Norman "Tim Williams" <saxifrax@pacbell*dot*net wrote in message ... Norman, Looked like SQL to me.... Tim "Norman Jones" wrote in message ... Hi T, Sub TestIt() If CAR.FAC_NO = HEAD.FAC_NO Then If BALANCE.COMP = "NIL" Then If BALANCE.Year = 2005 Then If BALANCE.PER_NO = 99 Then If BALANCE.ACCOUNT Like "5%" Then If HEAD.AREA Like "333%" Then If HEAD.AREA Like "666%" Then If HEAD.AREA Like "999%" Then 'Your result code here End If End If End If End If End If End If End If End If End Sub Note, all single quotes changed to double quotes. --- Regards, Norman wrote in message ups.com... Hello, Is it possible to use more than one LIKE statment in an Excel Macro? Here is what I have: WHERE CAR.FAC_NO = HEAD.FAC_NO AND ((BALANCE.COMP='NIL') AND (BALANCE.YEAR=2005) AND (BALANCE.PER_NO=99) AND (BALANCE.ACCOUNT Like '5%') AND (HEAD.AREA like '333%')) Which works... But, I want to add more LIKE statments. i.e. ....AND (HEAD.AREA like '666%') AND (HEAD.AREA like '999%')) How ever I get errored out. The LIKE statements grabs groups of number with a common beginning three digits. But it seems I can only do it for only one set, number multiple numbers. Any suggestions? Tmuld |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple If Statements | Excel Worksheet Functions | |||
Multiple IF statements looking up multiple ranges. | Excel Worksheet Functions | |||
Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
Using multiple IF statements | Excel Discussion (Misc queries) | |||
multiple IF statements | Excel Worksheet Functions |