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 strongm 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
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
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

renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
582
SoftwareRT
SoftwareRT
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
261
combo
combo
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
85
techie131
techie131
GPnew
  • Locked
  • Question
Power Query
Replies
5
Views
146
GPnew
GPnew
GPnew
  • Locked
  • Question
Power Query Extract from pdf 1
Replies
2
Views
109
GPnew
GPnew

Part and Inventory Search

Sponsor

Back
Top