OK except for the -(minus sign)!

  • Thread starter Thread starter Ady
  • Start date Start date
A

Ady

Hi There

I have a report that looks at a query. One field in the query is:
If yes how were you aware of company name?
Within the cell there is a drop down box with answers such as:
website
trade show
brochure.

On my report I am trying to count the number of cells with "website" in
them. Here is my formula:

=Sum([If yes how were you aware of company name?]='Website')

This formula works except for one problem. It correctly counts all the
fields with "website" in them but displays a minus sign in front of the
answer. How do I get rid of this minus sign?

Report shows: -12
Report should show: 12

any help on this matter would be highly appreciated!

Thanks in advance.

Ady
 
Back
Top