Querying BCM data

Status
Not open for further replies.
K

kayess

Hi there

I'm trying to build a simple report: show me all CONTACTS where (various
criteria are true) AND the payment status for the ACCOUNT they're associated
with equals PAID.

I have a feeling the reporting functions built into BCM are not robust
enough for what I'm after, but if someone could help me figure out how to
connect with BCM data through Access or SQL, I'd be fine.

Any insight? I'd be grateful.

Thanks!
 
On 3/13/2010 8:21 AM, kayess wrote:
> Hi there >
> I'm trying to build a simple report: show me all CONTACTS where (various
> criteria are true) AND the payment status for the ACCOUNT they're associated
> with equals PAID.
>
> I have a feeling the reporting functions built into BCM are not robust
> enough for what I'm after, but if someone could help me figure out how to
> connect with BCM data through Access or SQL, I'd be fine.
>
> Any insight? I'd be grateful.
>
> Thanks!
Which BCM?

Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Try Exchange Online http://bit.ly/free-exchange-trial
Please vote "helpful" if I helped you :)
 
Status
Not open for further replies.
< Fail to install BCM 2007 (English) on Windows 7 64 bit (Danish) | Offline database >
Similar threads
Thread starter Title Forum Replies Date
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
A BCM does not work with Windows 10 1703 any more BCM (Business Contact Manager) 3
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
S BCM Project Task Order BCM (Business Contact Manager) 1
T Lost access to remote BCM database BCM (Business Contact Manager) 4
crazyboy Problems connecting to BCM on Server Using Outlook 2
J Problems connecting to BCM BCM (Business Contact Manager) 16
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
M At last a BCM alternative... Outlook Customer Mngr 365! BCM (Business Contact Manager) 0
S BCM view customization BCM (Business Contact Manager) 1
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
K BCM Reports: Timeout Expired BCM (Business Contact Manager) 0
K BCM hide subfolders BCM (Business Contact Manager) 1
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Trial/Beta program for BCM replacement BCM (Business Contact Manager) 8
A BCM crashes immediately after start BCM (Business Contact Manager) 2
A Two Problems with BCM BCM (Business Contact Manager) 0
J BCM 2013 displays wrong form for account and business contact BCM (Business Contact Manager) 1
A Latest updates kill BCM 2013 BCM (Business Contact Manager) 0
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Diane Poremsky Outlook 2016: No BCM Using Outlook 0
Diane Poremsky Outlook 2016: No BCM BCM (Business Contact Manager) 17
wallisellener BCM and MSSQL2012 BCM (Business Contact Manager) 2
M Can I use BCM projects for this BCM (Business Contact Manager) 1
R BCM Reporting of repeat calendar entries BCM (Business Contact Manager) 0
Eduardo Macias BCM 2013 with SQL Express 2014 BCM (Business Contact Manager) 5
A Upgrade BCM System from 2010 to 2013 BCM (Business Contact Manager) 0
A BCM crashes after Windows 10 update BCM (Business Contact Manager) 1
C BCM Text Boxes & tabs are too short when downloading to Office 365 BCM (Business Contact Manager) 0
jChambler Cant install BCM on windows 10 BCM (Business Contact Manager) 12
S BCM screen Layout BCM (Business Contact Manager) 7
Diane Poremsky BCM Errors after Upgrading to Windows 10 Using Outlook 1
J Missing BCM TAB Main Menu - 2007 BCM (Business Contact Manager) 2
M Modifying BCM Database using Access BCM (Business Contact Manager) 1
jChambler BCM not installing properly with Outlook 360 BCM (Business Contact Manager) 3
S BCM crash Atheros Addin 2010 Using Outlook 1
R Installing BCM BCM (Business Contact Manager) 0
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
G Future development of BCM BCM (Business Contact Manager) 5

Similar threads

Back
Top