DCOUNT Challenge. Is this possible?

[michaelxmas]

Hi - does anybody know if its possible to do a DCOUNT which counts the number of fields that include a given text.

For example, instead of:

DCount("*","Table1","Field1 = " & [Field2])

Can we use something that says?:

DCOUNT("*","Table1","Field1 INCLUDES " & [Field2])

Can't find any advice on this.
Thanks for the help
Michael

 

[MStef]

Send a short example of your mdb, (access 2000 or 2002-2003),
and tell what you want to do.
See you tomorrow.

 

[MarkK]

In SQL there is a "LIKE" operator you can use with strings and wildcards ? and *. So if your WHERE clause looks like...

WHERE Field1 LIKE '*test.x??'

... your query will return records where Field1 looks like ...

This is only a test.xxx
mathtest.xls
join the contest.xyz

 

[michaelxmas]

Hi MStef/Lagbolt - thanks for the advice - not had internet access for a couple of days so just got chance to take a look at your help. I'll give it a go and let you know how I get on. Cheers.
Mick