I'm importing some data from a text file. In short, I'm trying to make this report (which is typically paper-based) database ready. The only problem I'm having is populating a value in this one column (Acct Unit).
I've used a mid query to extract data from column "Inv Code 1" into a temp field. This value is applied to certain lines and changes throughout the course of the data (ex "01.01.001.000" eventually becomes 01.01.002.000) so as I populate down into "Acct Unit" field. I always need it to grab the last known value.
I was thinking that a DLast/DMax query might do the trick but I'm a little fuzzy on implementing it.