>>Look at
DOW(datefield, 2)
>
>Not sure how does this help me. I guess, I didn't explain my need very well. I have a numeric field in a table called nDow. I want to show options with days of weeks
>Monday Tuesday ... Friday and have my field to be a controlsource for the option group. Borislav and me both have the same idea of adding invisible Sunday to the option group. This way the second available and visible option Monday will be saved as 2 in my table (exactly what I want, since a week starts with Sunday).
Naomi,
I'm lost. My solution was based on there being a date field. Now I don't know what to think. The solution could be as simple as your using SET FDOW TO 2 or doing some modulus 7 arithmetic.
If you tell me what you're trying to do here with the numeric field, it would help.
George
Ubi caritas et amor, deus ibi est