Using wildcards in DMin formula

[Guest]

I'm trying to return the earliest LeadTimeDate of a record if other
CompareParts have the same beginning characters.

The following control expression works fine:
=DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] =
Forms![NormalizeTest]![CombinePart]")

I need something like the below control expression to return the earliest
LeadTimeDate of all records with the beginning characters. I've tried
everything and can't seem to use the wildcards within this formula. Any idea
how I can rewrite this?
=DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] = Like "*
Forms![NormalizeTest]![CombinePart]"")

Thanks so much,
Alex

 

[fredg]

I'm trying to return the earliest LeadTimeDate of a record if other
CompareParts have the same beginning characters.

The following control expression works fine:
=DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] =
Forms![NormalizeTest]![CombinePart]")

I need something like the below control expression to return the earliest
LeadTimeDate of all records with the beginning characters. I've tried
everything and can't seem to use the wildcards within this formula. Any idea
how I can rewrite this?
=DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] = Like "*
Forms![NormalizeTest]![CombinePart]"")

Thanks so much,
Alex

Try:

"[CombinePart] Like '" & Forms![NormalizeTest]![CombinePart] & "*'")

 

[Douglas J. Steele]

I'm trying to return the earliest LeadTimeDate of a record if other
CompareParts have the same beginning characters.

The following control expression works fine:
=DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] =
Forms![NormalizeTest]![CombinePart]")

I need something like the below control expression to return the earliest
LeadTimeDate of all records with the beginning characters. I've tried
everything and can't seem to use the wildcards within this formula. Any
idea
how I can rewrite this?
=DMin("[LeadTimeDate]","NormalizationQuery","[CombinePart] = Like "*
Forms![NormalizeTest]![CombinePart]"")

Thanks so much,
Alex

Try:

"[CombinePart] Like '" & Forms![NormalizeTest]![CombinePart] & "*'")

Or, since he seems to want the wild card at the beginning,

"[CombinePart] Like '*" & Forms![NormalizeTest]![CombinePart] & "'")