Re: Query

["Brian Brosch" <Brian_Brosch@xxxxxxxxx>]

You can do this in Excel if you donât have anything more elegant. Set up an ODBC connection for an external data source and you can write all the queries you want with MS Query.

-----Original Message-----
From: bpcs-l-bounces+brian_brosch=nkusa.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+brian_brosch=nkusa.com@xxxxxxxxxxxx] On Behalf Of Carr, Wally
Sent: Thursday, March 04, 2010 7:14 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Query

John,

What do you have by way of query tools?

-----Original Message-----
From: bpcs-l-bounces+wallyc=bergquistcompany.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+wallyc=bergquistcompany.com@xxxxxxxxxxxx] On
Behalf Of John Quirk
Sent: Thursday, March 04, 2010 8:19 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Query

Running BPCS405cd

Looking to query the following.

Customers invoiced to the state of MI

 

Sales to invoice to customer(ID#) with state code MI

 

Breakdown by ID #

 

Any info would be helpful..

 

 

Best

John

 

BSM PUMP CORP

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

BSM Pump Corp

180 Frenchtown Road

North Kingstown    RI  02852

401 471-6391