ms access - Dcount function with wildcard characters

Question

posted Feb 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

I have a table containing project and region column.

Project  region
Exp       UK
Exp1      uk/usa

Dcount("[project]","[tablename]","[region]='uk'")

It will return 1 instead of 2.

Can someone help how can I count this with wildcard.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Reply

深蓝 · Answer 1 · 2021-02-06T00:58:57+0000

Use LIKE with wildcard characters.

Consider:

Dcount("[project]", "[tablename]", "[region] LIKE 'uk*'")