>>>>Should I be able to test each of the selects separately, starting from the bottom? In the top select, does the line
>>>>
>>>>NVL(T1.RatingSum,0) + NVL(T2.RatingSum) as TotalRating, ;
>>>>
>>>>presuppose that a field named RatingSum already exists, or can it be a field that is defined in this query
>>>>Thanks
>>>>Steve
>>>
>>>To test, start from the query defined in parenthesis and run it with output to a cursor and then browse that cursor (remember my suggestion in your other thread).
>>>
>>>In fact, I think it will be easier for you to first run all your sums into cursors and only after you get the intermediate data for each hour and verify them, join all these cursors together and get the final result you're after.
>>
>>
>>How do I prevent foxpro from turning numbers like 201311242210 into notation like 2.012E+11 ?
>
>Where do you get such numbers? In Excel?

For indexing, I created a numeric field called mindex and stuffed it with all the date data: year, month, day, hour, minutes, like: 201211011711
Now, when I try to use mindex in an SQL expression, if I want to strip off the hours or minutes, I first have to do a
str(mindex) and that returns in scientific notation because

If nExpression has Numeric or Float type, and nLength is less than the number of digits in nExpression, and , STR( ) returns a value using scientific notation.