DCount Question

B

Ben

I have a DCount that works great. However, I want the number to be in a set
of parenthesis like (9). How can I code that into the DCount line?

Thanks
 
S

Stuart McCall

Ben said:
I have a DCount that works great. However, I want the number to be in a
set
of parenthesis like (9). How can I code that into the DCount line?

Thanks
Click to expand...

Well the Dcount function won't allow it, but you can surround the result
yourself, like this:

strResult = "(" & Dcount("*", MyTableName) & ")"
 
Top