05-21-2009 10:32 AM
I've done quite a bit of searching around and either I'm missing something obvious or I'm going about this the wrong way. What I'm trying to do is create a report based off of the Company List that gets returned from a query I run. I don't need any of the actual Contacts in this report (most of the companies don't have a contact, only the company), just the companies.
In case there is another way to go about this, the business wants to generate reports for their sales people based off of some criteria that we put in the queries. There is one person who will be generating these reports and they need to be emailed to someone else to get distributed. This gets rid of the option to just print them.
Appreciate any help and sorry if this has been answered before (couldn't find it when searching).
05-22-2009 02:14 PM
05-22-2009 07:47 PM
05-22-2009 10:14 PM
05-23-2009 12:43 AM
05-23-2009 07:53 AM
05-23-2009 08:57 AM
05-23-2009 10:45 PM
@jprof7 wrote:
And it actually gave you the report based on only the companies that were in the lookup?
Yes
Did you do anything special after running a query?
As I stated, I ran the query on the company screen.
Using which report?
I believe it was the company detail but it would be the same with any company report.
05-27-2009 03:02 PM
This might be what you are looking for although you didn't specify which version of ACT! you are running. In 2009 what you can do is, as Roy mentioned do a Company-based lookup instead of a contact one.
Lookup > Companies > Advanced Query. Make sure Companies is specified in the search for text box then specify Companies in the type combo box. In the field name specify Zip Code, then Greater than or equal to, then a lower bound Zip Code value then click the add to list button.
Add another row specifying companies type, Zip Code field, Less than or Equal to, then an upper bound zip code in the value text box. Click add to list then preview if you like. Next click OK to run the query, then either Yes or no to save the query, then select replace lookup. This will create a lookup of companies in a zip code range that you can use any of the company reports on.
Remember to specify current lookup as the dataset for the company report and ACT! will use the companies that were returned from the Zip Code query.