| Filter for a report | |
Posted: Fri Sep 19, 2014 9:28 am |
Points: 0 |
|
NeilT |
GoldMine Journeyman |
|
|
Joined: 03 Jan 2011 |
Posts: 44 |
Location: GB |
|
|
|
|
|
|
|
HI, I am using GM 2013. One of my activity codes is FMI and I would like to create a report, by cloning one of the standard reports, which shows all of the completed activities with this code. Can anyone help me with the code for the filter please?
This code works for pending activities but I want completed.
cal->rectype>" ".and.cal->rectype<>"H".and.char(cal->accountno,1)<>"Q".and.cal->accountno=contact1->accountno.and.cal->actvcode="FMI"
Thank you in advance for any help or suggestions. |
|
|
|
|
| | |
Posted: Tue Oct 28, 2014 7:49 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
I don't see any reason why this wouldn't work:
ContHist->accountno=contact1->accountno.and.ContHist->actvcode="FMI" |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|