ed_j
asked on
Look up a value in a table based on a date
Act Date Acct_Bal
1 05/01/2006 1000.00
1 05/05/2006 3000.00
1 05/20/2006 -500.00
1 05/21/2006 4000.00
1 05/24/2006 -200.00
If I want to know what is the account balance on 5/7/2009, I want the query to return 3,000.00 the value on 5/5. The highest value before the next change on 5/20
1 05/01/2006 1000.00
1 05/05/2006 3000.00
1 05/20/2006 -500.00
1 05/21/2006 4000.00
1 05/24/2006 -200.00
If I want to know what is the account balance on 5/7/2009, I want the query to return 3,000.00 the value on 5/5. The highest value before the next change on 5/20
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.