Using wildcards in DMin formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
Try:

"[CombinePart] Like '" & Forms![NormalizeTest]![CombinePart] & "*'")
 
fredg said:
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
Click to expand...
Try:

"[CombinePart] Like '" & Forms![NormalizeTest]![CombinePart] & "*'")
Click to expand...

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

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