J
John
I am impoprting a text file into Access 2007 and trying to copy down data
from one field to the one below, unless there is data already present. If
data is present in the field below, then that data should be copied until a
new field with data is present.
I am using DLookup as follows with ID as an autonumber field.
DLookUp("[Account]","Corp0203","[ID] =" & [ID]-1) ; Criteria "Is Null"
The problem - DLookup only copies one time for each field of data each time
the query is run instead of copying until it finds data. I can repeatedly run
the query until it is all filled in but this is not desireable.
Thanks for any suggestions
from one field to the one below, unless there is data already present. If
data is present in the field below, then that data should be copied until a
new field with data is present.
I am using DLookup as follows with ID as an autonumber field.
DLookUp("[Account]","Corp0203","[ID] =" & [ID]-1) ; Criteria "Is Null"
The problem - DLookup only copies one time for each field of data each time
the query is run instead of copying until it finds data. I can repeatedly run
the query until it is all filled in but this is not desireable.
Thanks for any suggestions