>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 again, I found out what I needed and I was confused with an AS and a caption. Sorry, I need more caffine to get my brain kicked started.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope