select custid, custfname, custlname, custaddress, custcity, custstate, custphone1,
sum (itemtotal) as SalesTotal from lineitems A
inner join Possales C on C.possaleid = A.saleid
inner join customer D on D.custid = C.poscustid
and A.itemdesc like '%Class Enrollment:%'
and C.posdate > '06/01/2015' and C.posdate < '03/15/2016'
group by custid, custfname, custlname, custaddress, custcity, custstate, custphone1
Scraps Galore is a Xyron Studio X store.
You can find all your Xyron products at our store, with prices competitive with nationwide retail locations
We have a large selection of both rolled and packaged stickers throughout the store
including the Tumblebeasts line.
|Come in to see our huge selection of paper, including our impressive selection of Bazzill and WorldWin Cardstock.|
Scraps Galore is an EK Elite store
This means we carry a large portion of the EK Success product line.