Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2008
    Posts
    40

    Unanswered: need help converting string of numbers to integer...

    Hi

    I am trying to combine long integers from a number of fields together but keep the resultant number as an integer. I am not simply adding them but tacking each one on to the next as in the following

    Not = 65 + 78 +83 + 96
    But = 65 & 78 & 83 & 96 (to get 65788396)

    I think what I am getting is a text entry instead of a number...is there a way to convert it...any ideas?


    ok i figured it out since then...now I need some other help - I will post this separately as well. I have a table of numbers now and they are associated with people and I want to create a query like you might find in a travel guide that explains distances between two places and it is the same places in the column and row headings - I can't seem to figure out how you would then subtract one from the other....I mean the values that were assembled previously...
    Last edited by oompa_l; 06-10-08 at 20:49.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •