Display brackets around a query Count

[ChrisPanet]

Hi all, here is what im wanting to achieve...

I have a Count() on a few forms which obviously counts all records, what im wanting is to do is display brackets around the count number so rather than looking like this '1' on a form it looks like this '(1)' like most microsoft products discplay counts like Outlook etc.

Can anyone help?

Thanks in advance

 

[ZmrAbdulla]

Something like this?

="(" & Count([EmpID]) & ")"

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me

 

[ChrisPanet]

Brilliant, thats exactly what i wanted, many thanks