Format a Number in a Query 2

[leonepaolo]

Hi,

In a query, design view, I calculate the average of a number. I don't want to show any decimal places. How can I reformat the number within the query.

Any assistance and/or comments will be greatly appreciated.

Thanks in advance,
Paolo

 

[SkipVought]

Hi,

Use the INT function.

Int([i]expression[/i])

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[PHV]

An alternative is the Round function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[leonepaolo]

Hi,

Thanks to you both.

If I modify the SQL, it works, but then I lose the ability to modify the query in design view.

I've tried Int(Avg("Field")) in the design view Criteria row, but I get an error when I try to see the results.

Can it be done here or must one modify the SQL

Thanks again,
Paolo