Yes, but under Percent of sales I got whole numbers. From looking at your code it seems like you were counting the rows. I tried that...

Jack Corbett (11/28/2008)

---

Here's how I'd do it:

;With cteItemTotalSales As

(

Select

IP.ItemNumberSK,

Sum(SI.Qty) as total_sold

From

item_purchase IP Join

sales_item SI On

IP.ItemNumberSK = SI.ItemNumberSK

Group By

IP.ItemNumberSK

)

SELECT

st.StoreName,

st.StoreCountry,

si.ItemNumberSK,

si.ItemName,

(SUM(si.Qty)/Convert(Float, total_sold)) as sales_pct

FROM

STORE st Join

ITEM_PURCHASE ip On

st.StoreNumberSK...

I am using an Access...

Thanks, but I am still lost.

My app is the only app toching ITEM_PURCHASE. I am new to this so... I am wondering could you guide me a little bit more....

Thanks I am new to this so I dont know where to start..could you be able to help me with that?