select companyname from qmd_affiliations where affiliationtype = 'CMC' order by companyname select companyname from qmd_affiliations where affiliationtype = 'GPO' order by companyname
  • Address
    #qcfAccountDetails.address#
    #qcfAccountDetails.address2#
     #qcfAccountDetails.city# #qcfAccountDetails.state#, #qcfAccountDetails.zipcode#
  • Acct. Manager
    #qryCustomerManager.FirstName# #qryCustomerManager.LastName# unassigned
  • Segment
    #qcfAccountDetails.segmentDesc#
  • Distributor
    #qcf_distDetail.primaryDistrib#
  • Num of Units
    #year(now())-1#: #qcfAccountDetails.num_units_lastYr#
    #year(now())#: #qcfAccountDetails.num_units_thisYr#
    #year(now())+1#: #qcfAccountDetails.num_units_nextYr#
  • Food Mgmt Co
    #companyname#
  • GPO
    #companyname#
  • #_mdmType# ID
    #qcfAccountDetails.mdmid#
  • #_mdmType# ID
    #qcfAccountDetails.mdmid# - #htmleditformat(qcfAccountDetails.mdmCompanyName)#
    •
  • #label#
    #data#
    •
  • #label#
    #data#
    •
  • Addl Profile Info
    #htmleditformat(qcfAccountDetails.comments)#