Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lookups

New Member
Posts: 2
Country: Canada

Lookups

I can't do a lookup with 2 peices of criteria from one field? Wierd

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Lookups

Sure you can using the advanced query.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Astute Commentator
Posts: 5
Country: Canada

Re: Lookups

I use the advanced process all the time, but can't make it do this. I have a field called Receipt and 8 different pieces of data in the field. Like "June" and "Sep". I build the lookup with "equal to" and it won't run? I've tried single and double brackets. To no avail. 

Nickel Elite Contributor
Posts: 508
Country: USA

Re: Lookups

What about the AND vs OR conditions?  Should be OR from what you describe...

Richard Brust
ACT! Certified Consultant
richard@rbrDataSolutions.com
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Lookups

[ Edited ]

Hello rustyrunr1te,
When you say you have 8 pieces of data in the field, is this a multi-select dropdown field that has more than one item selected?

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.