Espinoza84
Registered User.
- Local time
- Yesterday, 21:43
- Joined
- May 30, 2008
- Messages
- 55
Hello all,
I have a table with a column called "DIR FILE".
Now in this column the values are " RX RX", "RWXD", and "all all". anyways what RX RX means is "read-only', RWXD means "read-write-excute-delete, and "All all" means all.
I want to run a query, and select this field, but I do not want it to display RX RX, RWXD, or all all, instead I want for the query to display read-only, read-write-execute-delete and all,
anybody know the code i would have to put in the "Field:" section in the Query Design view,
thanks.
I have a table with a column called "DIR FILE".
Now in this column the values are " RX RX", "RWXD", and "all all". anyways what RX RX means is "read-only', RWXD means "read-write-excute-delete, and "All all" means all.
I want to run a query, and select this field, but I do not want it to display RX RX, RWXD, or all all, instead I want for the query to display read-only, read-write-execute-delete and all,
anybody know the code i would have to put in the "Field:" section in the Query Design view,
thanks.