G
Guest
I have the following expression in a query, which is not quite working the
way I want:
NewStatusDate: DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] =
'" & [CombinePart] & "'")
I'm trying to return the earliest LeadTimeDate where the text in CombinePart
is included in the text in a CombinePart on another row. I think I'm missing
a wild card????
For example:
CombinePart LeadTimeDate NewStatusDate
11- 3/1/05 1/1/05
11-22-33 1/1/05 1/1/05
11-22-33-44 5/1/05 4/1/05
11-22-33-44-55 4/1/05 5/1/05
Thank you
way I want:
NewStatusDate: DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] =
'" & [CombinePart] & "'")
I'm trying to return the earliest LeadTimeDate where the text in CombinePart
is included in the text in a CombinePart on another row. I think I'm missing
a wild card????
For example:
CombinePart LeadTimeDate NewStatusDate
11- 3/1/05 1/1/05
11-22-33 1/1/05 1/1/05
11-22-33-44 5/1/05 4/1/05
11-22-33-44-55 4/1/05 5/1/05
Thank you