the access db is in local lan how can i reach by internet? i can run dts package on web server but how can i find the access db?

Can...

I've solved with the sql statement thanks for your help

I think that it is better work with TSQL when is possible, that manipulate data on client side;  both for performance...

Hello Chris  

below there is table and data

the query is this  i just need to add a "%sale" fields to the results

this field is calculate from tot_draw/unsold

SELECT sum(draw)...

thanks for your suggest

now all rows are selectd but i still have the divide by zero error

287 row(s) affected)

Server: Msg 8134, Level 16, State 1, Line 2

Divide by...

hello thanks for your fast reply

i've added the row

draw / sum(returns + short + notdeliver+damaged) AS '%sale'

but i get this error

Server: Msg 8134, Level 16, State...

thanks a lot

useful link

I modify the query and put CASE WHEN condition for periods i need

SELECT x.iss_no, x.pro_cod, x.pro_name, x.distrib, x.dis_dat, sum(ret_qty) AS unsold,

CASE

WHEN DIS_DAT BETWEEN '01/05/2003' AND '05/31/2003'

THEN X.DISTRIB else 0...