Dan, How did you word the "create view" portion of the view definition?
Ben Petersen On 24 Jun 2002, at 17:34, Dan wrote: > Hi all. I have the following view: > > select (min(orddate)) as FirstDate,(max(OrdDate)) as > LastDate,(count(OrdDate)) > AS TotalOrders,(sum(Total)) as TotalRevenue,clientnum from orders group by > clientnum where cancelled <> 1 > > on which I'm trying to design a report. However, when I use the report > designer, only the column <clientnum> appears available. What happened to > the other columns? > > Thanks, > Dan > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
