on 11/28/02 1:41 AM, Dave Mennenoh at dmennenoh .at. mgicommunications .D.O.T com wrote:
> 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?
I have not understand task well,
But may be you need additional field for tmp fill to change sort order?
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on .at. lists .D.O.T macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
