Results 1 to 7 of 7

Thread: Access Query

  1. #1
    johnw
    Guest

    Access Query

    I am having one of those days already, can anybody remind me how to merge data from two fields into one in my query.

    eg I wish to join wt = "AA" "/" job = "00505"
    wish to create contract "AA/00505" <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Query

    Try it like this:

    wt = "AA" & "/" & cstr(job)

    I assumed that 'job' is a field or a variable that has the value "00505".

  3. #3
    johnw
    Guest

    Re: Access Query

    Thank you very much for that Bart, worked a treat, I had a mental block.

    Cheers have a good day.

    John

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Query

    Glad I could help.

    About that good day, it is a public holiday over here, the sun is shining bright, trafic queues to the beach solved and ......
    I have to work, we are doing an euro conversion these days, that is a lot of waiting and waiting.
    We arranged a pc with dvd player, a beamer, a set of could speakers and about 20 movies on dvd. Think we'll survive...

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Query

    >>Think we'll survive...

    The conversion, or the euro itself? <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Query

    I hope both, that

  7. #7
    New Lounger
    Join Date
    Jan 2001
    Location
    Breda, Netherlands
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Query

    Hallo Bart,

    I read you have done an euroconversion. I hope it was also in Access.
    Actually a customer of us has an Access database with a field that contains currency in NLG. He wants to convert these to euro's but keep the history in NLG. I think the only solution is adding a column with the euro in it (based on the column for NLG).
    Do you have some suggestions?

    Anouk
    Nederland

Posting Permissions

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