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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUERY

Status
Not open for further replies.
gc1234

gc1234

Programmer
Mar 4, 2004
94
0
0
GB
Hi

Is it possible to list a figure hence 45.61234 as 45.62, in other words reduce decimal places
 
Sort by date Sort by votes
What application are you talking about?
 
Upvote 0 Downvote
If you right click on the query, and select properties, there's a format option. If it's tables you talking about, go into the design view and change the format in there. Be warned that this will only change the way the numbers look, not the underlying numbers themselves.

 
Upvote 0 Downvote
Ah.... see but i need a query, cannot access the db physically, its live
 
Upvote 0 Downvote
By what means exactly are you accessing this data then? Can you be more specific?
 
Upvote 0 Downvote
Soorry , live db, access via a front end in ASP to run updates only
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
128
combo
combo
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
50
techie131
techie131
GPnew
  • Locked
  • Question
Power Query
Replies
5
Views
91
GPnew
GPnew
GPnew
  • Locked
  • Question
Power Query Extract from pdf 1
Replies
2
Views
77
GPnew
GPnew
S
  • Locked
  • Question
Adding Parameters to an Excel Query (NOT Power Query)
Replies
0
Views
19
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top