megatronixs
Registered User.
- Local time
- Today, 15:07
- Joined
- Aug 17, 2012
- Messages
- 719
Hi all,
I'm going nuts on this one. I use a query to get a balance ledger that is less or equal to the day passed and only interested in the TOP 1 ORDER BY set to DESC.
The above code will give me 3 results instead of 1 (all are the same actually)
After spending almost 2 hours looking in the net, I can't find nothing :-(
where do I go wrong?
Greetings.
I'm going nuts on this one. I use a query to get a balance ledger that is less or equal to the day passed and only interested in the TOP 1 ORDER BY set to DESC.
Code:
SELECT TOP 1 BALANCE_LED
FROM CUSTACCT
WHERE ACCOUNT_MVT_DATE <=#2/1/2015#
ANS BRANCH_NO =12345
AND ACCOUNT =123456789
ORDER BY ACCOUNT_MVT_DATE DESC;
After spending almost 2 hours looking in the net, I can't find nothing :-(
where do I go wrong?
Greetings.