>>I have two fields in a view/grid, one date, one numeric, call it section. There are two rows for each date, but each has different section:
>>
>>date1 section1
>>date1 section2
>>date2 section1
>>date2 section2
>>
>>I want to show in the grid MDY if section1, and CDOW if section2. Something like:
>>
>>iif(section=1,MDY(mydate),CDOW(mydate)) to give
>>
>>01/12/97
>>Monday
>>01/13/97
>>Tuesday
>>
>>in column controlsource? I've seen this done, but can't seem to get it working. This column is Readonly. Any ideas?
>
>what is *give* ?
>same as:
>give=iif(section=1,MDY(mydate),CDOW(mydate))
>or
>store iif(section=1,MDY(mydate),CDOW(mydate)) to give
Oh, sorry, that's math talk...
to give = 'should show the results as'
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.