Convert Currency To Text
Jan 25, 2007Hi.
I really need to convert fields with currency data into text values AND still keep the decimal point and the numbers after it.
But how?
Russ
Hi.
I really need to convert fields with currency data into text values AND still keep the decimal point and the numbers after it.
But how?
Russ
I am sure it must be very simple but I can't find the command!
I need to convert a currency value to a text value for use in a combined string, say £123.00, to the text string "£123.00".
Basically I want one of the reports to say "£123.00 each less x% discount".
Currently I am using :
[Door Price] & " each less " & [Discount] & "% discount"
which will display "123 each less x% discount"
I could add the £ sign in code but if I add the .00 as well I will then have problems with a price of say £123.50!
Surely there must be a simple command that does this for me?
Cheers!
John
Hi All.
In my calculation in a query:
Cost: Sum([Cost]/12*(DateDiff("m",[StartDate],Now())))
Cost is Currency;
StartDate is Date.
The result look like Numeric format I would like to have Currency format. Is it possible?
Thanks.
I have a field that adds up hours and minutes from a number of fields control source set to:
=HoursAndMinutes(([PaidHours]+[HolidayHours]+[OverTime])*[Pay]/100)
Where the Pay field contains the rate of pay in pence.
This then displays the value in the following format 15:00 what I would like to do is have this value displayed as Currency it makes no difference if I set the format to Currency is there a was to have it displayed as currency ie,
£15.00 any help would be appreciated.
dear frnd,
i have a access program for printing cheque. i want to use a text box which automaticaly convert number ito digits from user input text box.
Is it possible to convert a number (whether in the "Standard" or "Currency" format) into words ?
View 5 Replies View RelatedI am importing a spreadsheet from Excel - the problem is that one of the columns in excel has a currency and text format (ex. $123,000 in B5 and 3M in B6). I know in Excel you can have both formats in one column since each cell can be formatted individually - how do I replicate this in Access?
View 9 Replies View RelatedHow do you make the amount in a currency text box appear red if its negative? Right now it shows in parenthesis but I would like it to be red as well. Is this possible? It's also a calculated text box if that makes a difference.
View 4 Replies View Relatedhow to change default currency in Access 2013 to a "foreign currency" (i.e. to Indonesia Rupiahs) without changing control panel (Region/Language>currency) - now setup as USA ($US)?
View 3 Replies View RelatedHello, I have a Field in a Table called Fund Codes and they are entered as text: 1, 2, 3, 4 all the way to 1000. Now i need to find away to change 1 to 001, 2 to 002, 3 to 003, 10 to 010, but leave 100 as 100 and 222 as 222, so only add 0s to numbers from 1 to 99. Is there a way to do it? I know i can change the text to numbers and use format to do that, but i need to leave it as text. Please help. Many thanks!
View 11 Replies View RelatedI have a table with the following fields:
Tool Text
Tool_ID Text
Description Text
The Tool_ID field holds a number if the tool provides a tool id. However, if the tool doesn't provide a tool id, the text "No tool ID given" is automatically placed into the field. Therefore, it needs to remain a text field for this reason and others that are too long to go into.
Anyway, I created a query that pulls only one specific tool which always provides a tool ID. Therefore, the results of my query will always have a number in the text field "Tool_ID".
Question: Is there a way to convert the text field to a number field within the query?
Thanks in advance!
~ Greg
I used the format text box in my query design to generate weekdays as text from my date field. It works great. However, I was hoping to produce some graphs where I could use those weekdays as 7 categories to plot against some other data. Now I am finding that to be a problem as the "real" format is a date and when I try to change the format in excel it creates this random number. Any suggestions on how to get around this problem. Thanks a bunch.
View 6 Replies View RelatedMorning All,
In a table I have a text field (Meeting Date) which contains the date in the format: "Wednesday 22 March 2006"
How do I convert this to a date of format dd/mm/yyyy?
I have created another field of type date called MDate, in the same table, and have tried experimenting with an update query.
CDate(Left([Meeting Date],4) & "/" & Mid([Meeting Date],5,2) & "/" & Right([Meeting Date],2))
But this has not worked. (If someone could explain the significance of the numbers in the function that would be helpful also - Access help did not provide this information)
Hi, I get the user input from a text box in a form, then i use it in the query.
in my query i used the DateDiff function in the expression. should I convert the data type from string (the user input from the text box) to date type first before using the DateDiff function?
in the SQL view, I wrote the following, but it says incorrect:
SELECT availability.machineName,
(DateDiff("d",CDate(Forms!frmMain!txtStartDate),CDate(Forms!frm Main!txtEndDate))+1)*24 AS totalMonthlyHours, availability.type
FROM availability
WHERE (availability.date)>=CDate(Forms!frmMain!txtStartDate) And (availability.date)<=CDate(forms!frmMain!txtEndDate)
GROUP BY availability.machineName, availability.type;
Thanks in advance.
Im trying to construct a query which returns a field that has 21 different types of values.
Is there a way to assign a text value to each numeric value when the results are displayed?
Eg: 21 = "Local Sales", 22 = "National Sales", 23 = "International Sales".. and so on.
Ive looked at the Choose and IIF functions but I cant seem to work it out
..............
Anouther little problem, which should be basic. I want to exclude certain records with values such as 31 and 41 and 42.
When i type <> 31 or <> 41 <> 42 in the criteria they are all still displayed. Although when I type one of those criteria by themselves they ARE EXCLUDED. Is there something dumb I am missing here??
thanks in advance.
how to convert the value of option box ( 1, 2, 3, 4 ) into text.In my database, I want my field to contain "Permanent", "Seasonal", " Project", "Probationary" rather than 1, 2, 3, 4. How to get it in text ?
View 1 Replies View RelatedI have a field that is a combo box that I would like to convert into a text box. When I try to change the 'display control' to 'text' I loose all the information that is displayed in the field. I want to keep the current values that are there now, just do away with the combo box.
I have tried simple things like copy and paste, but that just makes the new field a combo box as well.
Hi,
I have a database with a query that returns a list of printers. This is created by finding all the printers in the database that take a perticular cartridge by code. Sample below.
PrinterName
-----------------
Some Printer 1
Some Printer 2
Some Printer 3
ETC
What I want to do is take the results from the query and convert it into a single line of text and place it into a column of a table related to that cartridge code.
So if say the cartridge code '12345' returns a list of printers such as;
printer 1
printer 2
printer 3
I want to take this data and turn it into a line like this;
printer 1, printer 2, printer 3
I then want to take this new line and place it in a column called Desc in another table relative to the original cartridge code.
table should look like this after query.
BEFORE:
CartCode | CartDesc | Price | Desc
12345 | Something here | 10.00 |
AFTER:
CartCode | CartDesc | Price | Desc
12345 | Something here | 10.00 | printer 1, printer 2, printer 3
I hope what I have said makes sence. I am pretty new to access and feel I have done quite well so far. Please can someone help me solve this problem?
Thank you
I want to have a question in my query that does not get answered by date but by a concatenated field named "MonthYearPeriod".
We always forget how many days in a month. But we remember the month and year. So for say a Sales Range of Nov 2006 to Oct 2007, we prefer to respond to the criteria question as: 11-2006 and then 10-2007.
FiscalMonth and FiscalYear are both Long Integer number fields in the table.
Query field concatenated:
MonthYearPeriod: [FiscalMonth] & "-" & [FiscalYear]
criteria line:
Between [Month-Year START DATE] And [Month-Year END DATE]
However, i get other crazy time periods. So this is not working. Maybe on the Query field box, I need extra coding to convert the number to text?
I assume that a Dash sign between the month and year are fine.
Thanks
Hello all:
I have a database with the following fields: Last_name, First_name and Mid_name.
These fields are concatenated into a field called Full_name using this method: =[First_name]&" "&[Mid_name]&" "&[Last_name].
I wish to have the Full_name field convert the text in it to proper case.
Any ideas on how to go about it?
Thanking in advance,
Dion
How do you convert text stored as 300 (which is 3 pm) into a time field?
View 8 Replies View RelatedI have a report where I need to display a box with the following:
="text text text " & url &" text text text"
I need the URL to be bolded, but not underlined or blue. The URL is a variable, so I'm building the text using a string. It looks like the only way to set part of the field to bold is to make it rich text and add html bolding instructions, but that converts the url to a hyperlink. I don't want it to be a hyperlink, just text.
I need to convert a numbers column in an access table to a text format
View 3 Replies View RelatedHow do I convert '130330' to date in Access? I want to convert to 03/30/13?
View 1 Replies View RelatedI've got an address box on my form. When someone enters 'London' inside the box, I want only 'london' to be changed to all-caps.
View 5 Replies View RelatedI have an ms access Database(2013 version). There are about 10000 records. There are some columns with field property of "short text" but contains the values like that 0.4,7, 9.0 etc I would like to convert the "short text" into "double" without loosing information.
View 3 Replies View Related