Results 1 to 2 of 2

Thread: Querying Access database while converting data

  1. Sep 13th, 2012, 09:46 AM #1
    Shuter
    Shuter is offline

    Thread Starter
    New Member
    Join Date
    Nov 2011
    Posts
    11

    Querying Access database while converting data

    Hi everybody,

    I have a Access database that is full of data like 01Ta05. Where Ta means 30, so the value of this is = 31.05. What I want to ask is if it is possible to build a VBA macro or a query that would recalculate that string to is numerical value and than search for other related data. Has anybody some experience with this?

    Thank you,
    Shuter
    Reply With Quote Reply With Quote
  2. Sep 14th, 2012, 01:46 PM #2
    nO_OnE
    nO_OnE is offline
    Hyperactive Member
    Join Date
    Oct 2010
    Location
    Indiana
    Posts
    457

    Re: Querying Access database while converting data

    If all of your data follows the same scheme, then yes, it would'nt be too hard.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width