Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In a Query how do I set the amount of decimal places to go to. 2

Status
Not open for further replies.
KaayJaay

KaayJaay

IS-IT--Management
Jul 6, 2004
64
US
I have a fields that does a division calculation, but it gives me about 10 decimal places and i only want 4, how can i format the query output on a calculated field.

KaayJaay
 
Sort by date Sort by votes
Right click on the field and select properties, there is a decimal places box in which you can specify the amount you want.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mhshane
  • Question
Is this the best way to do this query? 1
Replies
9
Views
253
mhshane
mhshane
C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
581
dhookom
dhookom
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
598
breezett93
breezett93
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
1K
strongm
strongm
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
705
rashmibala
R

Part and Inventory Search

Sponsor

Back
Top