Thanks Robert I'll try that!
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 Robert Christian
Sent: Monday, January 02, 2006 9:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Year end annual sales
Happy new Year Michelle Try this its easy in Bus query thing drop in to
excel than you can do anything you like bob for each Customer Where
Customer.Company = cur-comp no-lock,
each InvcHead Where InvcHead.Company = Customer.Company
and InvcHead.CustNum = Customer.CustNum
and InvcHead.invoicedate >11/30/2005 and InvcHead.invoicedate
<01/01/2006
no-lock:
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 Robert Christian
Sent: Monday, January 02, 2006 9:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Year end annual sales
Happy new Year Michelle Try this its easy in Bus query thing drop in to
excel than you can do anything you like bob for each Customer Where
Customer.Company = cur-comp no-lock,
each InvcHead Where InvcHead.Company = Customer.Company
and InvcHead.CustNum = Customer.CustNum
and InvcHead.invoicedate >11/30/2005 and InvcHead.invoicedate
<01/01/2006
no-lock:
----- Original Message -----
From: Michelle VonBokern
To: vantage@yahoogroups.com
Sent: Monday, January 02, 2006 10:03 AM
Subject: [Vantage] Year end annual sales
Happy New Year everyone! Is anyone here today? :-)
Does anyone have a report that details annual sales per customer? I
have
a sales rep report that Todd so gallantly helped me on recently; but
cant use that unfortunately because a majority of my customers have
multiple sales reps and it is not picking up all the info.
I am just looking for a very basic report listing every customer with
their annual sales for 2005? Can I do this somehow in Business Report
Manager? I am very horrible at Report Builder and cant figure that
program out for the life of me :-(. I know that I can go through sales
analysis to get this info if I am really hard pressed, but the details
of all the parts is a lot of wasted paper and makes it more of a
hassle
to just get to the end totals for each customer.
Thanks in advance if anyone can help me.
Michelle Von Bokern
Office Manager
Advance Engineering Co.
PH: 630-628-3445
FAX: 630-628-3449
mvonbokern@... <mailto:mvonbokern@...>
[Non-text portions of this message have been removed]
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
SPONSORED LINKS Manufacturing software Membership database software
Database mortgage software
Pda database software Database management software Database
marketing software
------------------------------------------------------------------------
------
YAHOO! GROUPS LINKS
a.. Visit your group "vantage" on the web.
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
------------------------------------------------------------------------
------
[Non-text portions of this message have been removed]
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