Here’s a very handy SQL Query to find the last time you met with your contacts… Go to Lookup | SQL Queries and paste this into the Top ½ of the Window:
select contact1.company, contact1.contact, contact1.key1, conthist.userid, conthist.ondate, conthist.ref from contact1, conthist where contact1.accountno = conthist.accountno and conthist.recid in (select max(recid) from conthist where srectype = 'A' group by accountno) order by key1, ondate
Then Click Query!
Don’t Forget you can Send the Results of the Query to Excel with a Right-Click | Output to Excel.
This and over 60 other very use queries are await you in The GoldMine Guide to SQL Queries!
PS – Don’t forget about the GoldMine Premium Edition Webinar Coming up on Tuesday!