Hi all, I am in need of some assistance. I have a table that has fields like
so:
User_ID - Income_ID - Date - Estimated - Actual
I select records based on Date... In cases where the Estimated field is
empty I need to select the next most recent entry and populate this entry
with it... Normally, I select just the records I need for a given month...
So, say for instance a user enters a bunch of data in May... they then come
back and enter data in November. I need the estimated data from May to come
forward so I can use it in November...
Anyone have any suggestions for doing this?
Dave
©2002 Dave Mennenoh |
