Try this: CREATE VIEW vwSKUTotals (SKU,Units,Sales) AS + SELECT SKU, COUNT(units),SUM(sales) + FROM table+ GROUP BY SKU
Then base your report on this view. "Dick" <[EMAIL PROTECTED]> wrote: >OK... That I figured out...That gets the info on the screen in a tabular >form, �BUT.. how do I turn that data into a report? �Wouldn't it have to >based on a table or view? > >----- Original Message ----- >From: "William Cook" <[EMAIL PROTECTED]> >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >Sent: Friday, March 28, 2003 11:30 AM >Subject: [RBASE-L] - Re: Report... Duh! > > >> SELECT SKU, COUNT(units),SUM(sales) FROM table GROUP BY SKU >> ----- Original Message ----- >> From: "Dick" <[EMAIL PROTECTED]> >> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >> Sent: Friday, March 28, 2003 9:22 AM >> Subject: [RBASE-L] - Report... Duh! >> >> >> >> Ever feel like you're just having a mental time-out? >> >> Trying to define a report that with pull distinct SKU's from todays >> sales, along with total of no of units and total of days sales amt by >> SKU. >> >> Have tried various ways & �I can't make it work. >> Know this ain't hard. >> HELP >> >> > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promos=380455
