This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Course Of The Month
6 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Format currency, percentage and dates using vba
Posted on 2009-05-13
Hi,
Is there a way to format fields into currency, percentage and dates using vba? I have a table that have 3 fields:
Cost, Percentage and Date of Purchase.
right now, those fields are showing just numbers but i would like to format them as mentioned above. Table name is called MainTable. thanks for the help.
Is there a way to format fields into currency, percentage and dates using vba? I have a table that have 3 fields:
Cost, Percentage and Date of Purchase.
right now, those fields are showing just numbers but i would like to format them as mentioned above. Table name is called MainTable. thanks for the help.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
Active today
Sounds like you haven't designed your table with the correct data types for the fields.
Correct this, and the data will display correctly with the default format of your Windows.
/gustav
Correct this, and the data will display correctly with the default format of your Windows.
/gustav
gustav,
I am importing excel files into my database using vba. so i lose the format i setup for the table everytime i import them. this is big project i am working on now and i am trying to automate everthing. thanks.
I am importing excel files into my database using vba. so i lose the format i setup for the table everytime i import them. this is big project i am working on now and i am trying to automate everthing. thanks.
Active today
How could we know? But that explains.
If so, create a simple select query where you use the imported table as source and wrap the fields with CDate, CCur and CDbl:
Select
CDate([YourDateField]) AS YourDate,
CCur([YourCurrencyField]) As YourAmount,
<.. etc.>
From
tblYourImportTable
Percentage is nothing more that a decimal number.
Then use this query as source for your further tasks.
/gustav
If so, create a simple select query where you use the imported table as source and wrap the fields with CDate, CCur and CDbl:
Select
CDate([YourDateField]) AS YourDate,
CCur([YourCurrencyField]) As YourAmount,
<.. etc.>
From
tblYourImportTable
Percentage is nothing more that a decimal number.
Then use this query as source for your further tasks.
/gustav
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Access VBA Expected end of statement | 5 | 53 | |
| Excel 2007 Random Generate List Based on Defined Source Cells | 3 | 29 | |
| How to turn on numlock via VBS code? | 12 | 27 | |
| Using a combo box to search a form. | 3 | 35 |
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
Suggested Courses
Course of the Month6 days, 7 hours left to enroll
732 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.