Hello,

In the query design view I have a numeric field--whole number (no decimal places)--that I want to have displayed in a given format. However, when I try the line in the subject I get the following message.

Access can't evaluate an expression because a value's data type isn't compatible with its operator.

Can you please help? I've tried changing the data type in the table design, and I have also tried formats like #,###.00, but no I always get the same message.

I have also searched the Web but as you probably know there's almost no documentation about Web Apps.

Thank you
Leonel

Hi Leonel,

The following will work:


Add the format for negative numbers as needed.

Thank you Doug,

I had tried that. I've discovered the problem was I was not defining the result as an expression (but as an aggregation).

I ended up with Format(Sum([Field]),"#,###"). So, the aggregation is within the expression and the query field is defined as an expression.

Best
lg