Not sure what you mean by "the code that runs the query but here's the query.

Is this what you mean?

SELECT CONCAT(BOOKING.LDATE,BOOKING.SCHEDSTATUS), COUNT(BOOKING.LDATE)
FROM TRAPEZE.PROVIDERS PROVIDERS, TRAPEZE.BOOKING BOOKING WHERE
(BOOKING.LDATE = TO_CHAR (SYSDATE -5, 'YYYYMMDD') ) AND (BOOKING.LDATE
<= TO_CHAR (SYSDATE +6, 'YYYYMMDD') ) AND BOOKING.PROVIDERID =
PROVIDERS.PROVIDERID AND (SUBSTR(PROVIDERS.PROVIDERNAME,1,2) = 'KC') GROUP BY
BOOKING.LDATE, SUBSTR(PROVIDERS.PROVIDERNAME,1,2) , BOOKING.LDATE,
BOOKING.SCHEDSTATUS ORDER BY BOOKING.LDATE,
SUBSTR(PROVIDERS.PROVIDERNAME,1,2), BOOKING.SCHEDSTATUSNot sure what you --

Thanks in advance.

Richard


"CLR" wrote:

Take a look at the code that runs the Query......you should be able to change
it there......if not, post that section of the code and we'll take a
look......

Vaya con Dios,
Chuck, CABGx3


"Richard" wrote:

OS: XP, Excel 2000, Oracle 8-I

I have written an Excel Dashboard. I am constantly making
changes to it and need to pass it around in the office.

I store it on a shared network drive and dont have any trouble with the
Excel file, however the SQL Query file is stored on my computer and always
defaults to a path ending in the folder Queries.

I must physically go to the recipients computer and complete the process to
get it to work.

The next update to the Excel file requires starting the process over again.

How can I force the Dashboard to always look to the shared drive
for the SQL Query?

Thanks in advance.

--
Richard