I would like to create a view that is essentially the entire table, but with one exception. The original table has the SSN w/out dashes, and I would like to create the view to have all data fields including the ssn with the dashes. Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create a view
- Thread starter szaunbr
- Start date
For ssn field
You will have to save this as a query though, and reference as a table because to my knowledge access does not allow 'views'.
Hope this helps,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
Code:
select left(SSNFIELD, 3) & "-" & mid(SSNFIELD, 4,2) & "-" & right(SSNFIELD, 4)You will have to save this as a query though, and reference as a table because to my knowledge access does not allow 'views'.
Hope this helps,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
- Status
Similar threads
- Locked
- Question
