Dan, Use the SQL syntax version of aliasing in your CREATE VIEW statement:
CREATE VIEW myview + (Firstdate, LastDate, TotalOrders, TotalRevenue, ClientNum) + AS SELECT + (min(orddate)),(max(OrdDate)),(count(OrdDate)),(sum(Total)), + clientnum + from orders + group by clientnum + where cancelled <> 1 Bill On Mon, 24 Jun 2002 17:34:05 -0500, Dan wrote: >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? > ================================================ 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/
