Community
Showing results for 
Search instead for 
Do you mean 
Reply

Lookup not showing all the results

New Member
Posts: 4
Country: United_Kingdom

Lookup not showing all the results

I'm using the advance lookup to show all contacts with a profession of solicitor in the database, I know there are over 600 as I imported the excel spreadsheet myself. But when I use this lookup I get only 14 or so results returned, any idea?

 

I'm running Sage Act Pro 2012 on windows 7 pro

Copper Elite Contributor
Posts: 219
Country: Canada

Re: Lookup not showing all the results

Hi Rae@Focus

 

Are you using a User Defined Field to hold the profession or some other field?

Mark Rogers
Act! v16 HF5, Office 365 SBP
New Member
Posts: 4
Country: United_Kingdom

Re: Lookup not showing all the results

Hi,

 

You know what, I have just this second figured out the issue when I went back into Act to take a look at what you had said. The problems was, the person that wrote the excel spreadsheet (not me) had entered solicitor into the profession field but had spelled it wrong, so when I used the lookup and spelled it correctly, it only returned a few results, the correctly spelled ones.

 

Problem solved, even if it was indirect to what you said, thanks Smiley Happy

Copper Elite Contributor
Posts: 219
Country: Canada

Re: Lookup not showing all the results

Nice. Glad you got it to work.

Mark Rogers
Act! v16 HF5, Office 365 SBP