Thank you sssoooo much Jerry. You just saved my rear end.
Much appreciated!!!!!!!!!!!!!!!!!!!!!!!
Michelle Von Bokern
Office Manager
Advance Engineering Co.
PH: 630-628-3445
FAX: 630-628-3449
mvonbokern@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jerry Boyle
Sent: Tuesday, May 03, 2005 3:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] HELP w/ report PLEASE
You should be able to query the CustCnt table for this info. I just did
a
quick one and it worked. Here is the query:
for each Customer Where Customer.Company = cur-comp no-lock,
each CustCnt Where CustCnt.Company = Customer.Company
and CustCnt.CustNum = Customer.CustNum no-lock
BY Customer.Name:
I then listed the customer name, contact name, phone, fax, function.
Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 6.10
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Michelle VonBokern
Sent: Tuesday, May 03, 2005 4:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] HELP w/ report PLEASE
Does anyone know a way to get a listing/report of contacts per customer
that
I can export out of Vantage into Excel?
For the life of me I cant seem to find a field in Business Activity
Queries
when I try to create a report for this.
I know I asked this last week, but I received no answers and am
desperate.
Please, can anyone help me?
I need to submit a report for our new Midwest Sales Manager detailing
his
visit locations with contact info, and would rather not have to pull out
all
the info manually to put into a spreadsheet...
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Much appreciated!!!!!!!!!!!!!!!!!!!!!!!
Michelle Von Bokern
Office Manager
Advance Engineering Co.
PH: 630-628-3445
FAX: 630-628-3449
mvonbokern@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jerry Boyle
Sent: Tuesday, May 03, 2005 3:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] HELP w/ report PLEASE
You should be able to query the CustCnt table for this info. I just did
a
quick one and it worked. Here is the query:
for each Customer Where Customer.Company = cur-comp no-lock,
each CustCnt Where CustCnt.Company = Customer.Company
and CustCnt.CustNum = Customer.CustNum no-lock
BY Customer.Name:
I then listed the customer name, contact name, phone, fax, function.
Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 6.10
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Michelle VonBokern
Sent: Tuesday, May 03, 2005 4:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] HELP w/ report PLEASE
Does anyone know a way to get a listing/report of contacts per customer
that
I can export out of Vantage into Excel?
For the life of me I cant seem to find a field in Business Activity
Queries
when I try to create a report for this.
I know I asked this last week, but I received no answers and am
desperate.
Please, can anyone help me?
I need to submit a report for our new Midwest Sales Manager detailing
his
visit locations with contact info, and would rather not have to pull out
all
the info manually to put into a spreadsheet...
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links