Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

Conversion of nemeric value

I would like to know whether I can convert the numeric value into charecter value

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 4 Answers

If you just want to change the format to text in a query, you can use the Str function in your query. In MS Access, in the Field area of your query in Design View, you can type the following:
YourDesiredCharFieldName: Str([YourNumericFieldName]).

On the other hand, if you prefer to convert the data once and for all in your table, you can go to the Table Design View for that Table, change the Data Type of your numeric field to "Text", and close that window to save the changes. This will convert all of your data in that field from numeric to text permanently.

Posted on Aug 09, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

15 Answers

How to Convert Lotus Notes to PST, the Easy Way!


Download a NSF to PST converter from http://www.convertnsftopst.biz/
which can convert unlimited NSF file to PST files, This tool is effective for large size NSF files also.

Feb 19, 2013 | Computers & Internet

Tip

Tired of Converting WMV to iPad MP4


Have you ever spent several hours and been tired numerous different videos converters to convert WMV to iPad MP4

Aimersoft Media Converter - a powerful WMV to iPad MP4 converter permits you to convert WMV to MP4 for iPad freely. Free trial is available. If you don't know that How to convert WMV to iPad professionally, you can watch the following content. It will let you convert WMV to iPad MP4 as a specialist.

Here a guide will show you how to convert WMV to MP4 for iPad for watching on the iPad step-by-step. It just takes a few clicks to convert WMV to iPad MP4 files using this WMV to iPad MP4 converter software.

Guide: How to Convert WMV to iPad MP4

Step 1: Install and run the software.

Step 2: Click the pull-down menu pointed by the red arrow to add WMV files.

add your wmv files to the converter

Step 3: Choose the iPad MP4 format by clicking the "Setting" button.

choose the ipod mp4 format for your conversion

Step 4: Click "Start" to begin your conversion.

begin the wmv to ipad mp4 conversion
Now, you only need to transfer the converted files to iPad. Then you can enjoy your favorite files at anytime and anywhere on your iPad.




Connected information : music converter media converter ipod to mac iphone to computer ipod transfer

























on Jul 23, 2010 | Computers & Internet

1 Answer

Dd to dms conversion


Press the DMS button to convert between decimal degrees and degrees-minutes-seconds.
The DMS button is marked with the degree, minute, and second symbols. It's located above the [ENG] key, which is located above the [8] key.
For full details, start with the "Degree, Minute, Second (Sexagesimal) Calculations" section beginning on page E-22 of the manual. If you need a manual, you may download a copy here.

Jan 19, 2012 | Casio FX-115ES Scientific Calculator

1 Answer

I am trying to convert a Windows Media Video File to an mp4 using the Cucusoft Video Converter Ultimate. However when I start the conversion I keep getting an error that say?s: ?Install DataExtractor...


See whether another converter program can convert the file to verify whether the WMV file is corrupt or not.

I suggest using MPEG Streamclip (http://www.squared5.com/) to convert the file. MPEG Streamclip is free, but the installation process takes a little more time.

Please try downloading and installing MPEG Streamclip and see whether that has a problem converting the file. If it does, then you know that it's a WMV file corruption issue; otherwise, it's a Cucusoft issue and you'll need to report it to them.

Jan 03, 2011 | Cucusoft Ultimate DVD + Video Converter...

1 Answer

I do not know how to use the unit conversion feature i try to follow the instructions but it always says there is an error. Please HELP ME!!!!


Enter the value to be converted. Press SHIFT 8 to bring up the conversion screen then enter the two-digit code for the units, then press =.

For example, to convert 2 inches to centimeters:
2 SHIFT 8 0 1 =
and see 5.08

Sep 16, 2010 | Casio FX-115ES Scientific Calculator

2 Answers

Trying to use unit conversion feature and can't figure out how to use the feature


Assuming you want a conversion listed on the inside of the case:

Enter the value to be converted, press SHIFT 8 to bring up the conversion screen, enter the two-digit number for the conversion, then press =.

For example, to convert 2.1 inches to centimeters (conversion 01):
2 . 1 SHIFT 8 0 1 =
and see 5.334

Sep 15, 2010 | Casio FX-115ES Scientific Calculator

1 Answer

In the programs I have made when I use the Request enter a integer, I always have to press the alpha button before entering a # in the field when running the program, is their a way to program a request...


Hello,
The syntax of the command is as follows
:Request Message, VarName
where Message is a character string containing the message that will be displayed as a prompt, and VarName is the name of the string variable where the input will be stored.
If you want to input a numerical value you must convert it from character string to a numerical value (I know, it is like splitting hair but string 123456 is not the same as number 123456)
You convert from string to numerical value with the expr() command.
Exemple:
:Request "Value of a? ", s
:expr(s) --> a

That should do it.

Hope it helps.

Oct 15, 2009 | Texas Instruments TI-89 Calculator

1 Answer

Numeric key pad


Whats the model of your laptop?
I know that on some IBM models, there was a button called "Num Lock", and by pressing that on you activate the nemeric keypad under the ordinary letters


Good luck!

Dec 10, 2008 | Computers & Internet

3 Answers

CONVERSION OF NUMERICAL VALUE INTO TEXT IN M.S. EXCEL


to convert numbers into text, just add an apostrophe ' to the left of the number. When you press enter, the apostrophe will no appear, but the number will have the atrtibutes of text

Nov 18, 2008 | Microsoft Windows XP Home Edition

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

83 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...