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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

6 Answers

How can one move Notes emails to Outlook.


NSF to PST converter Lotus Notes to Outlook is most appropriate email migration tool to convert Lotus Notes databases in Outlook PST. This software saves converted mail items folders as PST, MSG, or EML files. You can use Lotus Notes to Outlook Conversion Tool for the conversion of Notes to Outlook successfully. A free demo version of this tool is also available at:- http://www.tools4recovery.com/nsf-to-pst-converter.html

Mar 30, 2015 | Business & Productivity Software

5 Answers

Notes to Outlook Conversion, How is this possible?


Latest Stellar Phoenix NSF to PST Converter which make your conversion procedure easily and fast. It has features to Converts all calendar items, NSF mails, contacts, to-do list, journal etc.This tool provides option to save converted mailbox in PST, Text, HTML and RTF file Format.

Jan 30, 2015 | Microsoft Office Outlook 2007: Windows

4 Answers

How do I import Entourage archived .rge files into windows outlook 2013?


http://entouragetopst.com/how-to-convert-entourage-archive-rge-files-to-pst-file-outlook-windows/

Jan 28, 2015 | Microsoft Outlook 2013 Software, English,...

10 Answers

How to convert OLM file to PST


SysTools Outlook Mac Exporter is highly recommended OLM file to PST file Converter to Convert .olm to .pst files which can easily Convert OLM files Outlook for Mac 2011 mails to Windows Outlook PST file. The software makes it possible for the Outlook for
Mac users to access the Mac emails and its related data items outside the Mac environment.
OLM to PST File Converter

Apr 17, 2014 | Microsoft Office Outlook 2007: Windows

1 Answer

Hello, i have 2 questions: 1- i need to know if there is away to convert "Arabic protected PDF book into DOC " 2- i need to know is there is away to supervise my team while the are dealing with...


PDF is the only document format that typically allows you to view the file, instead of editing with many means like data encryption techniques, passwords and local restrictions. Due to these actors, users prefer to convert PDF to Doc format so that they can access and make changes to the data. Once converted to Word format, files become open for modification, editing, printing, copying and extracting information. Using Doremisoft PDF to DOC converter is the most effective method to convert PDF to Doc with utmost ease and accuracy.This is an easy-to-use and efficient PDF to Word utility that converts PDF to Word DOC file with great precision. Good Preservation PDF Converter preserves all the elements of original PDF files, such as text, hyperlinks, images, layouts, tables, columns, and graphics. The best aspect about this utility is that as a user you can also convert password-protected PDF file. During the process of PDF to word conversion, the software prompts the user to enter the password. As a result, it is very important that the password of the PDF file must be known for PDF to Word conversion.Key Features of PDF to docx converter:
1.Support all Windows platforms, Windows Server 2008, Windows 7, Windows Vista, Windows XP, Windows 2003 and Windows 2000 2.Provides complete support to the conversion from encrypted PDF files and password protected documents 3.Preserves the Text, Pictures, and Layout even after the successful conversion of file from PDF to Word DOC format 4.Supports Unicode Character Conversion 5.Perform the PDF to DOC conversion at a very high speed 6.Allows user to convert entire document or only a specific page range 7.Converted files can be automatically opened immediately after conversion complete 8.Provides round the clock technical support 9. Preserve data structure, formatting and properties of content 10. This PDF to Word Converter is compatible with Microsoft Office 2010, 2007, and 2003.Pricing and Availability:Doremisoft PDF to Word converter is priced at $39.95 for single user license. You can downloaded online from Doremisoft pdf to word converter website

Sep 22, 2011 | Microsoft Office Professional 2007 Full...

6 Answers

How to convert pdf to excel


There are various websites that provide you this feature for free. You just need to upload your PDF document and you would get the converted document either right away or to your inbox.

This is one website that I could suggest immediatly

Mar 07, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Text box restriction


I hope this helps and thanks for rating my effort...any other questions...shoot em to me....The Fang.

Restricting character input You can use the SetInputTextType command to restrict the characters that the user can enter in the text input dialog box. For example, suppose an application contains an input text field for users to provide a numeric value, such as their age, and that the input text field has the variable name ageVar. To ensure that the user enters only numeric values in the text input dialog box, you could add the following code to your application:
fscommand2("SetInputTextType", "ageVar", "Numeric");
When users open the input text dialog box, they can enter only numeric values in the text fields.
For more information, see SetInputTextType in the fscommand2 function entry in the Flash Lite 2.x ActionScript Language Reference.

May 28, 2009 | Adobe Flash® CS3 Professional Full Version...

1 Answer

Transformed string to numeric values- does not display values


You can try to format the cell to number, if this doesn't give you the desired result - Use the custom feature and update your specific characters into values using 0

Apr 29, 2009 | SPSS 13.0 (30960UU)

2 Answers

Copy-paste


it should be

=7/4  or =100/30
and excel will give you a numeric result.

Oct 18, 2008 | Microsoft Excel for PC

1 Answer

Convert String to Nmuneric


Hi Saiprasad, Tough day huh?! :-) Try the following: Suppose "2" is in cell "A1" Type: =value(a1). Let me know if this helped and please rate my solution. Best, D.

Sep 03, 2007 | Microsoft Office Standard for PC

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

Related Topics:

82 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...