S
swichman
I am attempting to write a dlookup statement to match only part of a
text field in the where clause. For instance I have a TkNumber text
field with data T2.GC.01 and T2.CO.01 etc. T2.GC implies General
Conditions and T2.CO implies Change Order. It is always the case that
the implication can be found in the first 4 letters. Is there a way to
make this part of a where clause in the dlookup statement or does
somebody have a better way of doing this?? Sorry to be vague but I am
having a hard time explaining this. If anybody can help it would be
much appreciated. No free trips to the Bahamas this time though.
text field in the where clause. For instance I have a TkNumber text
field with data T2.GC.01 and T2.CO.01 etc. T2.GC implies General
Conditions and T2.CO implies Change Order. It is always the case that
the implication can be found in the first 4 letters. Is there a way to
make this part of a where clause in the dlookup statement or does
somebody have a better way of doing this?? Sorry to be vague but I am
having a hard time explaining this. If anybody can help it would be
much appreciated. No free trips to the Bahamas this time though.