>I know in the SELECT statement you can have a field as
>
>SELECT acmds.type AS Type
>
>How do you do this from the view designer?
Sorry brain dead here I want
SELECT acmds.type AS Type of Document
Where the heading should appear as Type of Document
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope