× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



PMP09 is the best place to start.

>>> akincer@xxxxxxxxx 08/04/03 08:23AM >>>
I am trying to put together a report on vendor spending that summarizes
all
items purchased over the past few years including purchased parts as
well as
services.  The report is per vendor/per item and will be sorted in "top
ten"
fashion.

My plan is to do this over the files that show paid invoices but I'm
not
sure if this needs to tie into any other tables such as parts,
movement
files, etc. The information also needs to include total quantities of
whatever unit it is that was purchased.

Can someone tell me the tables I need to query, any necessary joins,
and if
this is the best approach.

Thank you.

Alan Kincer - MCSE, A+
IT Section Manager - KI(USA) 
501 Mayde Rd. 
Berea, Ky. 40403 
 

"If you think no one cares if you're alive, try missing a couple of
car
payments."





=== [ KI (USA) Corporation - http://www.kiusa.com ]
====================================== 
Tel. 859.986.1420  --  Fax. 859.986.1485 
This e-mail, including any attachments, contains information from KI
(USA)
Corporation that may be confidential or privileged. Mail is intended
only
for those to whom it is addressed. If you are not the intended
recipient do
not copy, distribute, or take any action in reliance on the contents of
this
message. 
If you have received this e-mail in error notify the sender immediately
then
delete or destroy all electronic and hard copies of this
communication,
including attachments. 
KI (USA) Corporation's anti-virus system checks for known viruses.
However
you are advised to run your own virus check before opening any
attachments
received. KI (USA) Corporation will not accept any liability once an
e-mail
and/or any attachment is received. 
Views expressed in the e-mail are those of the author and not
necessarily
those of KI (USA) Corporation. 
============================================================================


_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21 
or email: SYSTEM21-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.