Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advance search ACT! 2008

Accepted Solution Solved
New Member
Posts: 7
Country: UnitedKingdom
Accepted Solution

Advance search ACT! 2008

Have a client who wants to be able to look up the codes he usese to identify his products. These are entered in one field as they may have more than one product. I.E. If you do a a search for B11 you get all the B1* . Is it possible to sort to the second digit.

 

 

Jim D PCC SCOTLAND


Accepted Solutions
Solution
Accepted by topic author pccjimd
‎09-25-2015 03:20 AM
Nickel Elite Contributor
Posts: 595
Country: USA

Re: Advance search ACT! 2008

Use Lookup | Advance Query with the Contains operator.
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com

View solution in original post


All Replies
New Member
Posts: 7
Country: UnitedKingdom

Re: Advance search ACT! 2008

Have with perseverence found answer - in advance searh in "value " field start with the letter only then on next line set "value" to b11 or what ever value your are searching for. But the problem now is when doing a multiple search for i.e. b11;c22;g4 then onc again you get a lookup with b1*;c2* need help please.
Copper Super Contributor
Posts: 206
Country: USA

Re: Advance search ACT! 2008

Try using the % wildcard character

 

The percent symbol (%) will work as a wild card character to find any combination of characters within a field. For example: typing %rob into the Contact field of the Lookup or Lookup By Example dialog box will find Robert Smith, Jim Roberts and any other contact records that have the adjacent letters rob in their Contact field.

Brad Marquardt
realtimeACT, Inc
Colorado, USA
New Member
Posts: 7
Country: UnitedKingdom

Re: Advance search ACT! 2008

Sorry did not explain that correctly  the client wants to look up specifics  I.E.  just B11;C23;G4 etc  in one look up without seeing other numbered B's;C's unless of course the are included with the set value
Solution
Accepted by topic author pccjimd
‎09-25-2015 03:20 AM
Nickel Elite Contributor
Posts: 595
Country: USA

Re: Advance search ACT! 2008

Use Lookup | Advance Query with the Contains operator.
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com