I have a VBscript which has a formula to do a DCOUNTA on a
database range that match certain criteria.

My question is how (with VBscript) do I amend the value of
the criteria, currently say SERVER, to be ="=SERVER"

The reason being is I'm getting the wrong matches and
counts. Sometimes I have the following

SERVER,SERVER1,SERVER2 . The server criteria counts all
three which puts my totals out. To make it an exact
match with DCOUNTA you have to enter the ="=criteria" in
the criteria cell. As my data is imported I need to amend
the current cell to surround it with the exact bits.

My attempts so far have not worked as they come back with
a FALSE value rather than the exact text. I also got a
VBscript error at one point.

Any help or suggestions?

Cheers

Jacqui