Results 1 to 6 of 6
  1. #1
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53

    About text to number conversion


    I have got two fields one contains numeric data and the other contains text both the fields are from a query, the text field has data i.e. either "A" or "B", Now I want to multiply Numeric field with text field (Where A='###' and B='####') and get the result in new field .

    [in my table text field has only A and B it doesn't have the values that A and B should contain]


    Name Value Text Result
    qwert 12,02 A
    gfdhug 32,02 A
    vgsuid 45,01 A
    dfjhis 78,201 B
    fgjog 456,0213 A
    goofgfhd 1,045 B
    where A= 145 and B= 150

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    As usual with Access there is more than one way to do this.
    I would try first: Create a new table to hold the values of A and B which could then be added to your current query with the appropriate join, which would make the numeric values available to use in an expression as a calculated field.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    am getting this warning !!!! if I want to add my assumption table to the query
    Attached Thumbnails Attached Thumbnails Unbenannt.png  

  4. #4
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    Yes I got it !!!!

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    What did you do regarding the error message
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    actually their was a data mismatch so I deleted the assumptions table and corrected the assumptions table and connected to value and assumption value

Please reply to this thread with any new information or opinions.

Similar Threads

  1. color number conversion
    By trevor40 in forum Programming
    Replies: 1
    Last Post: 03-03-2014, 12:18 AM
  2. Replies: 5
    Last Post: 12-21-2013, 11:19 AM
  3. Text to Caption conversion possible?
    By allstar45 in forum Forms
    Replies: 4
    Last Post: 02-15-2012, 07:18 AM
  4. Number conversion
    By FinChase in forum Access
    Replies: 2
    Last Post: 11-03-2011, 08:16 AM
  5. Conversion of database to text format.Help!!
    By sasipulikkal in forum Import/Export Data
    Replies: 3
    Last Post: 09-28-2009, 01:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums