How To Convert From Currency To Text.

May 26, 2005

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

View Replies

Convert Currency To Text

Jan 25, 2007

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

View 2 Replies View Related

Convert To Currency

Jun 3, 2005

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.

View 1 Replies View Related

Convert Value To Display As Currency

Apr 1, 2008

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.

View 3 Replies View Related

Currency Convert From Digits To Number

Nov 7, 2007

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.

View 1 Replies View Related

Forms :: Convert Currency (Or Number) Into Words

Feb 19, 2015

Is it possible to convert a number (whether in the "Standard" or "Currency" format) into words ?

View 5 Replies View Related

Currency And Text In Same Field On Table

Nov 16, 2007

I 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 Related

Currency Formatted Text Box - Amount To Appear In Red If Negative

May 9, 2014

How 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 Related

Tables :: How To Change Default Currency In Access 2013 To A Foreign Currency

Dec 20, 2012

how 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 Related

How To Convert Text To Numbers?

Mar 24, 2007

Hello, 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 Related

Convert Text To Number

Aug 2, 2005

I 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

View 4 Replies View Related

Need To Convert Weekday To Text

Oct 22, 2005

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 Related

Convert Text To Date

Aug 16, 2006

Morning 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)

View 3 Replies View Related

Convert Text To Date

Aug 10, 2007

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.

View 13 Replies View Related

Convert Numeric Value To Text

Mar 11, 2008

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.

View 6 Replies View Related

Convert Option Box Value To Text

Mar 8, 2013

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 Related

Convert Combo Box Into Text Box?

Apr 18, 2014

I 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.

View 5 Replies View Related

NEWBIE: How Do I Convert A Query To Text?

Mar 15, 2006

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

View 4 Replies View Related

Convert Number To Text In Query

Dec 1, 2007

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

View 5 Replies View Related

Convert Text To Proper Case

Oct 12, 2006

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

View 3 Replies View Related

General :: Convert Text Into Time

Feb 12, 2014

How do you convert text stored as 300 (which is 3 pm) into a time field?

View 8 Replies View Related

Reports :: Convert Hyperlink (URL) To Text

Apr 25, 2013

I 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.

View 2 Replies View Related

Tables :: Convert Numbers To Text

Jun 3, 2015

I need to convert a numbers column in an access table to a text format

View 3 Replies View Related

Queries :: Convert Text To Date

Jul 10, 2013

How do I convert '130330' to date in Access? I want to convert to 03/30/13?

View 1 Replies View Related

Forms :: Convert Certain Text From Textbox To Uppercase?

Jul 24, 2014

I'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 Related

Queries :: How To Convert Text Fields To Numeric

Aug 16, 2014

I 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