answersLogoWhite

0

ya sure we can do for convert a currency field to a number field.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is the type of field is used for money value in access?

Dear Sir, Currency is used as a type of field for money values in access. Dev


In Microsoft Access if the value 1000.5 is entered in a field in access that has been defined as currency data type then the value will display how?

$1,000.50 (depending on how you configure comma and currency symbol)


What are the data type available for Access table field?

Access Data Types are : Autonumber, Memo Text, Number, Yes/No, date/time, OLE object, Hyperlink, Currency.


What does dollar signs mean in Microsoft Access?

In Microsoft Access, dollar signs ('$') are used to denote currency data types. When a field is formatted as currency, Access displays values with a dollar sign, indicating that the numbers represent monetary amounts. This formatting helps users quickly identify financial data within a database. Additionally, it ensures that operations on currency values account for proper formatting and calculations.


What is a currency field database?

It is a database field which is designated for the use of currency values. It will only store numbers, and these will usually be displayed with the currency symbol.


What is the maximum number of characters a text field can store in Microsoft access?

32,767 characters in a standard text field.


What field with the data type can store a unique sequential number that Access assigns to a record Access will increment the number by 1 as each new record is added?

AutoNumber


A field with the data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.?

AutoNumber


When using Microsoft Access what is the default field size for a text field?

for 2003? i believe it is 255 characters. not positive though... (I use Access quite a bit, however, I am still not sure of that number)


What does currency mean in Microsoft Access?

It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.It is a field that is designed to store currency values. So you would use it for fields relating to money, like price or wages.


Difference between number and text type field in ms access?

This is true in any database (Access, Oracle). A number field is technically called a "NUMERIC" field. Only numbers can be inserted into a field that has this designator. A text field is for characters or numbers. It can be a "CHAR" (character), a VARCHAR (characters or numbers). It's basically a way of putting rules on columns--what type of data belongs there.


In Microsoft access When a record has an entry that is unique to them such as a customer number this field is called?

unique identifier!!