The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
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
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month7 days, 19 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.