Help !!!!!!.
Hi People!!, after your expertise !!. I have a table with numeric field. This field stores numbers between 1 - 7 ( which represent days of the week!). so day 1 = Mon day = 7. The field can have a maximum of 7 characters representing the 7 days in on week. So if the record had 1234 , this means mon , tues , weds, Thur, and if it had 56 this Would be Sat , Sun. I need to be able strip out each character and store the value on the corresponding day field. for example. 134 would populate monday (Field) with 1, Wednesday (Field) with 3 and Thursday (field) with 4. Have created a query and have tried to use the Right () function but this does not work. Which function do i need to look at each character!!.
Would be really grateful for some helpful advise!!.
Many Thanks
Milan
Hi People!!, after your expertise !!. I have a table with numeric field. This field stores numbers between 1 - 7 ( which represent days of the week!). so day 1 = Mon day = 7. The field can have a maximum of 7 characters representing the 7 days in on week. So if the record had 1234 , this means mon , tues , weds, Thur, and if it had 56 this Would be Sat , Sun. I need to be able strip out each character and store the value on the corresponding day field. for example. 134 would populate monday (Field) with 1, Wednesday (Field) with 3 and Thursday (field) with 4. Have created a query and have tried to use the Right () function but this does not work. Which function do i need to look at each character!!.
Would be really grateful for some helpful advise!!.
Many Thanks
Milan
