How to sort a set of contacts Alphabetically by Account Manager

[JoeFixes]

Maybe this is an easy task. We have a set of contacts all with varied account managers assigned. I am searching to learn how to list alphabetically either by state or by company name a set of contacts all for one account manage only. It seems like a simple request, yet I am stumped on how to achieve it.

Can anyone help?

Thank you

JoeFixes

 

[DJHunt]

This really depends on the version of GoldMine that you are using.

GoldMine Premium? Just Double-Click on the field label that you wish to Sort by.

GoldMine Standard? There are 13 Indexes pre-defined. Key1 thru Key5 are most commonly used for Account Manager.



DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US

 

[JoeFixes]

Hi DJHunt,

We are using V. 6.7. I want to first sort by account manager and then within the accounts for that person sort those by company or by state.

JoeFixes

 

[DJHunt]

1st Sort SQL Query

select *
from Contact1
where Key1 like '%DJ Hunt%'
order by Company

2nd Sort SQL Query

select *
from Contact1
where Key1 like '%DJ Hunt%'
order by State


DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US

 

[JoeFixes]

DJ,

Forgive my ignorance. Where do I get into the SQL Query sort options?

JoeFixes

 

[DJHunt]

Off of your GoldMine Menu.

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US