If I could quote U2: It works in mysterious ways :o))))
>Hi Boris.
>
>Thanks for replying (as usual) and, again, congrats on the award.
>
>Yes I'm sure I'm in the correct alias:
>
>1) I select it on the Data Sessions window
>2) all other fields from that cursor are allowed without problem (when I DO NOT select the offending 2 fields into the cursor)
>
>Strange thing though. I switched off and went home last night after sending the request. This morning I switched on, ran the sql and report and, the darnest thing, it worked fine.
>
>At the moment, unless it happens again later, I'm willing to put this down as a glitch.
>
>But don't you just hat mysteries like that!? :-)
>
>Cheers
>
>Terry
>
>>>
>>>Terry
>>
>>Are you sure you are in correct alias?
>>Maybe your current alias is some other Table/Cursor that have almost identical structure. try this just to be sure:
>>
>>SELECT ET.Operator, ET.Route, ET.Class, ET.Date, op.Desc as OpDesc, ;
>> SUM(IIF(BETWEEN( ET.date, ldStart1, ldEnd1), Number, 0000000)) AS Num1Pass, ;
>> SUM(IIF(BETWEEN( ET.date, ldStart2, ldEnd2), Number, 0000000)) AS Num2Pass ;
>>...
>>INTO CURSOS crsWhatever
>>SELECT crsWhatever
>>REPORT FORM ....
>>BROWSE NORMAL TITLE ALIAS()
>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.