G
Guest
Hi,
I have a query that returns the following records:
txtRecNumber RSum
8 3701
7 3030
6 30
5 0
4 769
3 0
2 1426
1 3800
"txtRecNumber" is the Record Number in Decending Order and "RSum" is a
calculated field. I want this query to return all the most recent records
which RSum is above the most recent "0". In this example it should return
3701, 3030 and 30. How do I edit my query to return just the records above
the most recent "0"? In other words, return records 6, 7 and 8 only.
Thanks in advance.
John G
I have a query that returns the following records:
txtRecNumber RSum
8 3701
7 3030
6 30
5 0
4 769
3 0
2 1426
1 3800
"txtRecNumber" is the Record Number in Decending Order and "RSum" is a
calculated field. I want this query to return all the most recent records
which RSum is above the most recent "0". In this example it should return
3701, 3030 and 30. How do I edit my query to return just the records above
the most recent "0"? In other words, return records 6, 7 and 8 only.
Thanks in advance.
John G