Help...Want to make integer down to hundreth in qry.

G

Guest

Hi All,
I have a query that averages days. As you can see below it averages
precisely and I only need to nearest hundreth. (00.00)
I have tried the query properties decimal place to 2, I have tried and input
mask....not a brainy move though wanted to at least try. I export this into
excel and can modify it there, but really would like it to do so in the query
itself for ease of use .
Can you help me please? Thank you!
Stephanie
AvgOfTotal Time to Transcription
0
1.9
2.33333333333333
0.666666666666667
0
0.571428571428571
1
0
 
J

Jeff Boyce

Stephanie

You can set the format of the field in your query to 0.0.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Stephanie PSVMC Portland OR" <Stephanie PSVMC Portland
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change format to results of Make table query 2
Make table query changes precision of number field 3
Using combo box in a form -- how to make drop-down work? 3
export to csv - can t get rid of decimal 3
In a Join, 0 doesn't join -0; why not? how to workaround? 2
I want to make the default value '0' in a report from crosstab qry 3
Go to specific record in a form PLEASE HELP ME :) 1
Need help in round up or down price to specific ending number 2

Top