01-24-2012 03:17 AM
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
01-24-2012 06:50 AM
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