W
William E Hannon Jr
The query below shows everything in the right order for
3329132335 52503
then
3329132335 52504
Then when I switch to Total function of first it randomly
give me the incorrect Index. The problem occurs consistently
for the same data, yet when I reload the data the problem
shifts around.
SELECT log.time_decimal, First(log.Index) AS FirstOfIndex
FROM log
GROUP BY log.time_decimal
ORDER BY log.time_decimal, First(log.Index);
time_decimal FirstOfIndex
....
3329132325 52502
3329132335 52504
3329132337 52505
....
Is there any other way around this??
Or will I be forced to go through each record and check for the
highest (max) decimal value and store it myself??
---
SELECT log.time_decimal, log.Index
FROM log
GROUP BY log.time_decimal, log.Index
ORDER BY log.time_decimal, log.Index;
time_decimal Index
....
3329132325 52502
3329132335 52503
3329132335 52504
3329132337 52505
....
3329132335 52503
then
3329132335 52504
Then when I switch to Total function of first it randomly
give me the incorrect Index. The problem occurs consistently
for the same data, yet when I reload the data the problem
shifts around.
SELECT log.time_decimal, First(log.Index) AS FirstOfIndex
FROM log
GROUP BY log.time_decimal
ORDER BY log.time_decimal, First(log.Index);
time_decimal FirstOfIndex
....
3329132325 52502
3329132335 52504
3329132337 52505
....
Is there any other way around this??
Or will I be forced to go through each record and check for the
highest (max) decimal value and store it myself??
---
SELECT log.time_decimal, log.Index
FROM log
GROUP BY log.time_decimal, log.Index
ORDER BY log.time_decimal, log.Index;
time_decimal Index
....
3329132325 52502
3329132335 52503
3329132335 52504
3329132337 52505
....