Average percentage field problem

[aarondewberry]

All

I have a query that gives me the average of a field ('effectiveness'). This datatype is number, format percent, 2 decimal place.

The problem occurs when the field displays '0.00'. When i run the query, it throws up no results, when i would like it to show '0.00'.

Any ideas?

 

[dhookom]

If you have a query, then you should have some SQL that you should share with us. It looks like you might be formatting an expression in your query which I think is not a good idea. I generally provide formatting in the form or report controls.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]