Search results

Yes, it's empty; I created it to extract the latest date where Balance was not empty. So, that in another query I can DLookUp to extract and plug the last balance into the empty Balance record. Thanks for following up on this. lechu.555

Thank you for replying; repeatedly; a few times per month. I am checking a projection to the actual date; there are days I don't trade, so I need to picked up previous record; so I create an 'intermediate' query to do a DVlookUp on that last trading day. At the moment, I am doing quick and...

Thanks for helping: In a select-query with three fields DateField, DateField2, and Balance; when a record has 'Balance' empty (null or blank) I need to populate DateField2 with last DateField record for which Balance was not empty. For instance...