 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / June 2006Make Table Question
Hi All, When tested without making the table my make table query returns numbers in the correct percentage format but in the 'made' table they appear as decimals. With the 'made table' being deleted and replaced how can I make the figures appear in the percentage format that I need? Ta. Bill Put Format(YourFieldName, "Percent") in one of the columns of your query. Hope that helps! Help - that darn well did it!!!! Many thanks. Bill > Put Format(YourFieldName, "Percent") in one of the columns of your > query. > > Hope that helps! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.