Replacing Numbers With Their Text Meaning

Aug 19, 2004

I created a database that has a field called "Corrective Actions." I want the user to be able to type in a series of numbers, in the following format: 001, 002, 051, 123. Each number has a certain meaning. For example, 001 means "Upgrade to current revision," 002 means "Replace Unit," and so on. Here is what I would like to happen: The user will type in the numbers in the appropriate format. When the user presses the tab key to go to the next field, I want the numbers to be replaced with the actual meaning. My problem is that I can not figure out how to accomplish this. Can anyone help me?

View Replies


ADVERTISEMENT

Replacing Null Values In Text Fields

Sep 10, 2007

Hi,

i have created a query from just one table, which is basically a list of Financial transactions.

There is a field called supplier code, in this query.

Most of the transactions have a supplier code, but there are a few that don't.

i've got another table that has the supplier name against the supplier code.

i want to bring this table into the query, so that i can show the supplier names against those records in the query that have a supplier code.

when i add this table and link the 2 tables up and put the supplier name into the query. The query excludes the records with no supplier code.

This is presumably, because they contain null values.

I've been reading about the Nz function and i think this is what i need to use.

i've tried this, but it still only brings through the records with a supplier code and not all of them.

How i've done this is to go into the design mode of the query and in the column that would have null values i have click "build"

in here i have the following formula.

Nz([Supplier Name],"No")

Am i doing anything wrong?

View 2 Replies View Related

Modules & VBA :: Replacing Value Of Zero To Blank Space In Text Box

Oct 4, 2013

How can I replace a '0' to a blank space and '1' to 'X' in 'Text Box' in a report ? The 'Data Type' is 'Yes/No' in the table.

View 6 Replies View Related

Numbers Stored As Text Convert To Numbers?

Jan 10, 2007

Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since the field is a text with input mask?

View 1 Replies View Related

Where To Find A List Of Meaning On Event / Type In MSAccess

Dec 16, 2007

Hi there,

This may mean stupid question to you but I find that some of the events or types in the properties which give me 'no meaning' at all.

For example, has module on form, on retreat on report. THIS IS ONLY A sample, my list would be endless.

Thanks in advance

View 3 Replies View Related

Sorting Text Field Containing Both Text And Numbers Sequentially?

Mar 26, 2014

We have a database that we use to track the tablets in our organization, a combination of Apple, Android, and Windows.

We label them with a hostname depending on their branding. Example below.:

APPLE01
APPLE02
APPLE03

ANDROID01
ANDROID02
ANDROID03

WINDOWS01
WINDOWS02

In the database we use the field name HOSTNAME for these entries. When sorting the field, due to it being a text field, we get the traditional sort of

APPLE01
APPLE02
APPLE10
APPLE100
APPLE101
APPLE11
APPLE110

ANDROID01
ANDROID02
ANDROID10
ANDROID100
ANDROID101
ANDROID11
ANDROID110

We would like to have them show up as

APPLE01
APPLE02
APPLE10
APPLE11
APPLE100
APPLE101
APPLE110
ANDROID01
ANDROID02
ANDROID10
ANDROID11
ANDROID100
ANDROID101
ANDROID110

What is the best way to tackle this?

View 1 Replies View Related

How To Have Text And Not Numbers In Text Data Type

Jan 13, 2006

I was wondering if there is a way of only allowing text in a text field - we need to do this for validation purposes when inporting a text file into a database. I have tried input mask but this only checks when entering new data - I have tried to use validation rule like"???????" however this means that there has to be 7 letters in each field and this is not the case. - the field is for town and a couple of the records in this field have numbers at the end which are incorrect that we want the database to reject :eek:

View 1 Replies View Related

Converting Text To Numbers

Jun 14, 2006

I wondered if someone could help.

I am using the Val () Function to convert a text field to number within a query which still gives me a text output.

P.S I do not have permissions to change within table as using Access as a front end to SQL via link Tables.

View 1 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

Treating Text Like Numbers

Oct 12, 2006

HI,
I have a field that contains mainly numbers, but the data type is set to Text because there are a few records where the numbers have a letter suffix.

Eg. Invoice numbers 100, 101, 102, 102A, 103 etc.

These suffixes are a result of poor data entry when the data was stored in Excel.

What I was to be able to do is sort this field and treat all entities as numbers. Currently when I sort it, it shows:

1
10
11
2
20
21
3
...etc

Is this possible, even though the data type is Text?

View 2 Replies View Related

Text + Numbers In 1 Field

Feb 17, 2005

Is it possible to have text and numbers in one field as access asks you specify the data type of that field?

View 1 Replies View Related

Calculate Numbers From A Text Field?

Dec 27, 2006

Ok, this one has me stumped.

I have a several fields on my form that are list boxes that must have text as the properties so I can populate the lookup data with things like" Severe rating = 7 points" and "Moderate rating = 3 points". I have another similar field where the choices are "High probability = 9 points" and "Low probability = 2 points" etc. A third field needs to show the total points (product) of the choices from the first two fields, i.e. 9 points x 2 points = 18 points. Then,
a fourth field needs to display where the answer falls in a grid, i.e. 1-14 points = Low, 15-29 points = medium, 30-49 points = high, etc.

How do I apply the calculations on the field choices if the field properties have to be text instead of number?

Thanks,

bugleboy:confused:

View 10 Replies View Related

Show Text In Drop Down Box Instead Of Numbers

May 31, 2007

Hi *,OK, still new to Access so I apologize in advance if that is a dumb question ;)I have a table "survey" where I wanna store number values (0,25,50,75,100 respectively). The user is supposed to use a form to input the data into the table. For this purpose, he/she is supposed to use a drop down box.So, is it possible that the drop down box does not show the values but instead a verbal description of these values (very important, important, average, etc.)? What I have tried was to create a table with the number values and use this table as data source for the drop down box... it shows the values but for the end user, verbal descriptions would be better...Thanks!Steve

View 2 Replies View Related

Importing Combination Text And Numbers

Oct 13, 2005

I am trying to import a field into a data, which is either a number, a number and text or just text. Within Excel the format has been set to text. The data type for the field in Access has been set to text and yet for those records which are only numbers when imported the record is shown as a number in scientific format. Does anyone have any ideas how I can get the number to be a number in its full format?

View 2 Replies View Related

Inserting Numbers Into Table Instead Of Text

Mar 8, 2006

Hi,

I have a strange problem, I have created this query:

INSERT INTO WEEKONE ( Assigned_To )
SELECT QPTActions.Assigned_To
FROM QPTActions
WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006');

It works, but it inserts Numbers into the Assigned_To column in the table WEEKONE. When I looked in the QPTActions database the values are text but the type of column was originally set to Number. I changed this to Text but its still inserting Number values into the destination table. How can I fix this?

View 1 Replies View Related

Wild Cards For Both Text And Numbers....

Dec 14, 2005

Hi,

I'm trying to search a field which has both names and numbers in it.

For purely text entries the wildcard search works just fine.... like this:

Like "*" & [What is Last Name?] & "*"

I can type in "Smi" and get all of the Smith, Smiths, etc.



However, when I try to use this for entries which include numbers (123), which should return "Smi123" I don't get any results at all.

Any suggestions? I can put in the SMI123 as straight text in the criteria box, and will get the appropriate record.... so I know it is there!

Thanks .....

Gordon

View 4 Replies View Related

Numbers With In A Disordered Text Field

Aug 3, 2006

--------------------------------------------------------------------------------

Hi,
Could you help me with the following.

Lets say I have table with one of the field header as 'notes'.
The notes is of type 'text'

In the notes column information like the following is typed out

Record 1 - MAX O.D 3.456" Min ID 1.2 and OAL 3.4"

or

Record 2 - MAX O/D 5.456" Min I.D 1.2" and Min Length 4.4 inches

Please note that as shown in the example there is no standard way of entering data. The only order that is followed is that the first numerical value corresponds to OD, 2nd corresponds to ID and 3rd corresponds to overall length.


I want to pull out the first numerical value (3.456 - first example, 5.456 -second example) and the last numerical value (3.4 -first example and 4.4 in second example). How would I be able to do this.

So the end result should be 2 more columns with max od as one and min length as the other.
Regards
George

View 1 Replies View Related

Option Stores Numbers, Need Text

May 23, 2006

Hi,

I am using group options and they store a number instead of the vaules you typed in, is there anyway of making a group option that will store values and not numbers?

View 9 Replies View Related

Separating Numbers & Text Into 2 Columns

Dec 29, 2005

Hi!!

I have a quick question. I have a field that has information that looks like the below. I need it to be in 2 separate columns, but there is no space between the numbers and text otherwise I would know how to do this in excel. Anyone know how to do this is excel or access?

11000031377A & A AMERICAN DETECTIVE BUREAU


It should be separated as....

11000031377 A & A AMERICAN DETECTIVE BUREAU

Any and all help would be appreciated!!! Thanks!

View 2 Replies View Related

Modules & VBA :: Converting Text To Numbers

Sep 19, 2014

I have a short text field where numbers such as "15.00", "2233.56", "-300.00" are stored. Now I want to convert the text field to numeric so that I have actually 15.00 or -300.00 stored as a double. I am going to do calculations on these fields. How can I achieve this conversion?

View 4 Replies View Related

Forms :: Storing Numbers And Not Text

Apr 24, 2014

I have a table with an auto number primary key field, and then several other fields, Address, Unit, Owner. I created a form with a combo box that looks up the Address from another table and populates the three fields when you click a record. I have it set to store the first value, (Address) in the table.

When I open the table, it appears as the primary key number, and not the address. It's very frustrating, as this happens a lot to me. What am I doing wrong? and how can I store the value I want, (Address) and not the primary key number?

View 1 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

Won't Paste Text If First 5 Records Are Numbers

Oct 13, 2014

I have a list of part numbers in Excel. The user needs to get them into Access so it can run the queries and get the data about all of the part numbers. The part number field in my form is formatted as text because the part numbers are alphanumeric. Right now the user copies the list of part numbers out of Excel and pastes them into my Access form. The problem is that if the first 5 part numbers are only numbers, then Access assumes the whole field can only be for numbers and all of the alphanumeric part numbers are pasted in as blanks. How can I stop this from happening? It works fine when one of the first 5 part numbers has a letter in it.

View 2 Replies View Related

Format Numbers In Query Text Field?

Nov 10, 2005

I have a field in a query that contains numbers and text (text field). The numbers displayed come from a percent calculation and display with many decimals ie, .99898745987245. Is there a way to eliminate the decimals with code in the query field? For example .99898745987245 to equal 99%? I can’t format the field as a number or percent because it has both text and numbers. HELP!!
Thanks

View 5 Replies View Related

Forms :: Numbers Separated By Comma In Text Box

Aug 26, 2013

I have a single 'text' box on a form that captures test scores. The person inputting the test scores puts in all of the scores separated by commas (77, 85, 100, 75.5).. Up to 6 test scores can be placed in this single text box. The field is formatted for text. What I propose to do is take the numbers in the text box and average them out and then display the test scores average in a number field named 'avescores' next to this field in the form. Once the inputer puts the series of scores into the text box, they would hit an 'update' button next to this box to 'update' the 'avescores' box. Right now they use a number pad and add up the numbers manually then place the average into the avescores box....

View 11 Replies View Related

Queries :: Postcodes - Return Only TEXT Before Numbers

Jun 17, 2015

I have a number of short postcodes ie

S43
GU10
ME8

etc etc

I want a run query to return only first characters before the numbers ie..

S
GU
ME

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved