Tuesday, June 29, 2010

GoldMine: Using SQL Queries to Count Records

A client asked: How do I know how many records I have?

If you ever wonder how many primary contacts, secondary contacts, or history items you have in your GoldMine database, there are simple SQL Queries to give you a count.

* First, go to Tools > Filters & Groups > SQL Queries Tab
* Copy and paste the queries into the top half of the screen
* Then click the Query button

For a count of primary contacts:
Select count(*) from contact1

For a count of secondary contacts:
Select count(*) from contsupp where rectype = 'C'

For a count of history records:
Select count(*) from conthist