Changing Currency Format On The Fly
Aug 30, 2006
Hello,
I would like to format the currency values in a query. There values will either be Euro or Pound. Is it possible to change the currency format "on the fly" in this way in a query?
I would like to have a variable currency format. For example:
If [fldCurrency] = [Euro] Then format [fldAmount] As Euro
If [fldCurrency] = [Pound] or [GBP] Then format [fldAmount] As Sterling
How does one format data as Euro?
Many thanks,
Dj_T
View Replies
ADVERTISEMENT
Nov 3, 2005
I am setting up a db for a ecomm site and the vendor prices are in 4 different currencies. I currently have the price fields data type as a "number" (long integer). Can the data type "currency" handle different currencies all in one table? Do I need to set up a seperate price table for all the products in each currency? Any help is appreciated.
View 2 Replies
View Related
Aug 20, 2012
How do I change all the currency fields (many many of them....)from $ to currency without going in and changing every form and fields manually.
View 3 Replies
View Related
Mar 24, 2005
This is probably the easiest question to answer if you know where to look but I don't.
Working in the UK with Access 2000 I need to set the field in a table to show Dollar $ USD however the only values I have are £ GBP and € as defaults.
Now I thought that I could get this to change if I changed my regional settings but then it occurred to me that if I do that and it changes then surely it would mean that who ever used this database in our global organisation would end up with a currency shown in their own local currency. Whilst this may not seem like a problem it is if you don't realise and quote a figure to someone in your local currency.
i.e. at present the UK £ = nearly $2 USD
So if someone in the UK read the figures and it dispalyed £400,000 and quoted this to a person in the USA when in theory the figure was meant to show $400,000 it could cause all sorts of issues.
Can someone tell me the correct way of choosing $ without it affecting anything else.
View 2 Replies
View Related
Aug 9, 2006
Hi
I have a field on a Form that displays values in Sterling (The Default on the machine) ie with the pound sign before the numbers.
I need to change the sign before the numbers to Dollar at a click of a button. I'm not interested in actually converting the values from Sterling to Dollar but only to change the sign. So I attached the code below to a Button's On Click Event, but I get an error = Expected.
Format([ControlName] , "$#,##.00")
ViRi
View 2 Replies
View Related
Aug 24, 2007
I have a calculated field in my query that takes the difference between to incomes. I want to format this field to currency. How can this be done?
View 1 Replies
View Related
May 17, 2006
Hi All,
My Querie:
I have a relational database, that is basically made up of a few tables, I will
simplify for this to two.
TblFieldNames and TblFieldValues
Basically using a form you can fill in a field (TblFieldNames.FieldName) and it
is then appended to TblFieldValues.FieldValue.
On the form the properties of the input text box are changed according to the
record selected in TblFieldNames.
Ie. ListBox with FieldNames from TableFieldNames
ListBox_AfterUpdate sets properties of
TxtValue
The Issue:
I have a Field in TblFieldNames that has a setting of Currency.
(TblFieldNames.FieldType = "Currency")
I have changed the TxtValue.Format = "Currency"
It doesn't:
A. Allow entry as a currency, ie. $ sign and thousand seperators
B. Append the details to the TblFieldValues Table, which it is going across to
into a field that is set as Text (this can't change)
I have tried:
Changing format of input Txt box
Changing Input Mask for inptu Txt Box
"$###,###,###" but doesn't work for me....
"/$###,###,###"
"/$###,###,###!"
I want it to allow me to enter in the Value as a Currency and append the value as a currency
ie.
Key Press = 12345
Field Shows = $12,345
Appends this value as Text?
Key Press = 1234567890
Field Shows = $1,234,567,890
Etc
Any ideas?
View 1 Replies
View Related
Jul 25, 2014
add a format to the Sql select for currency.This is just a section of the full code before
Code:
Function RunLWSCA()
Dim cnn As ADODB.Connection
Dim rstUplo As New ADODB.Recordset
Dim rstDiag As New ADODB.Recordset
Dim rstTemp As New ADODB.Recordset
Dim SQL As String
Dim strDiag
[code]...
View 12 Replies
View Related
Mar 31, 2014
I am just wondering if there is an advantage to using a currency field type in a table, vs. just using a number field? This is assuming that I am not working directly in the tables themselves and am using forms to display the data.
View 4 Replies
View Related
May 22, 2006
Hi,
I have a query with 3 fields - PaymentAmount and PaymentTotal. The third field is a percentage of the two e.g:
PaymentAmount = 10000
PaymentTotal = 12000
PaymentPercentage = 83.333333333333
In my form I would like a text box to display the two combined i.e. £10.000.00 (83.33%).
At the moment it displays 10000 83.3333333333333. I can use £#,##0.00 to format the current half, but how can I then format the percentage to display 83.33%?
Thanks
View 1 Replies
View Related
Jan 20, 2015
I have a Concatenate string of text and currency. When joined together, the currency format disappears. I need to reformat so the string stays together with new format. Below is what I have:
Public Function ConcatAgreementFundsCommitted(ID As String) As String
'/ Purpose: Generate a concatenated string of Tracks for selected line.
On Error GoTo Err_Handler
Dim lngLen As Long 'Length of string.
Dim strOut As String 'Output string to concatenate to.
[code]....
I need 'Funds_Committed' to display as currency.
View 2 Replies
View Related
Jun 4, 2014
I have this expression I created and I want to know how to format it as currency. I know how to do it with a regular field but the option is not available for an expression.
The expression:
Code : Charge: IIf([Rate] Is Not Null,[Rate],"0.00")
View 1 Replies
View Related
May 14, 2013
I run a MakeTable Query on some data to COunt the number of records and Sum the Value of $$$ in a Currency field.The results produce a Number for the Count, but the SUM of the Balances is returned as text.
To get the SUM I use the expression SumBal: DSum("[Balance]","[XAM_data]").
Why it won't return the SumBal in Currency format?
View 2 Replies
View Related
Apr 23, 2014
I am increasing prices and after increasing I am left with 4 decimal places and am trying to figure out how to run an UPDATE query to round down prices to the nearest 5 cents, examples below:
42.4516 round to $42.45
42.4659 round to $42.45
42.4489 round to $42.40
2.49 round to $2.45
2.46 round to $2.45
2.44 round to $2.40
2.04 round to $2
I am using "Currency" format.
View 10 Replies
View Related
Jun 30, 2012
I have created access database having field currency but it shows currency in $ by default I want to changed it to Rupee. How could it do?
View 1 Replies
View Related
Nov 13, 2013
How would I go about doing this?
View 6 Replies
View Related
Dec 7, 2007
How do I apply this - can't seem to get it right - just want to control user into putting whatever and two deciimals for pence.
99.99 input mask is halfway there - except I don't want to limit the pounds amount. putting 99999.99 makes entering 12.31 etc a little awkward.
Cheers
View 5 Replies
View Related
Feb 15, 2013
I want to store currency amounts but not use the currency format. My DB is set to use all currencies and provide in all currencies.
Do I use the SINGLE data type?
View 1 Replies
View Related
Jul 7, 2014
Is there a way to show negative numbers in brackets without selecting the Currency format?
I want to show (75,000.00) and not -75,000.00
View 2 Replies
View Related
Jan 9, 2007
I have a table populated with several thousand records-one field is a date field in the format of 5/5/2006. I have to change the data so that it is 5/05/2006 in order to import it into a SQL table.
I'm sure there has to be an easy way to do it, but I can't come up with it. Changing the imput mask on the field affects future data input but does not change what is currently there.
Any ideas or suggestions?
Thanks!
View 2 Replies
View Related
Dec 18, 2006
I have this problem, I have a field that updates by using the now() function. The problem is when I run a date query I have a problem due to the long date format. Is there a way to change all the records with a Long date format to a short date one?
Here is an example of what im working with:
Long Date: Januar 1, 2007 2:00 PM
Short Date: January 1, 2007
When I run a query I only get the records with the short date even though I have records with the Long Date format don't show up.
View 2 Replies
View Related
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
Jul 5, 2005
Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a backward way of doing things. Does anyone know how to elimate that default value from the format of a number field in general?
Thanks!
Carly
View 2 Replies
View Related
Nov 13, 2006
Hi All,
Is it possible to change the format of a date picker, for instance once i have selected a date, its is visible as 09/11/2006, can this be edited to just the month and the year 11/2006.
View 3 Replies
View Related
Jan 19, 2004
Hi,
I'm using a web based form to store dates (and other records) in an access database. I use the dd/mm/yyyy date format (europe. go figure)
Anyway, the problem is that when submitting an ambiguous date, as in 11/01/2004, access sees it as 01-NOV-2004 rather then 11-JAN-2004, as it should.
Why does this happen, and how can I fix it. I have no problem doing the fixing in the access file itself or in the SQL command that populates it- whatever works best.
Thanks,
-Ethan
View 5 Replies
View Related
Jun 4, 2014
I have a small issue, but cannot solve it. I have a form with a textbox bound to a time(7) on a SQL server linked table.
Even if I put the format as "Short time 24h" or "hh:mm" it will always come out with seconds, nanoseconds, etc as soon as you change record. I would like to avoid using the "current" event to keep the "hh:mm" at any record change.
View 4 Replies
View Related