DCount Question

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
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) & ")"
 
Back
Top