Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jonkovach

    Query to add text to data field

    Changed it to text, and it works! Thanks!!!!!!!!!!
  2. jonkovach

    Query to add text to data field

    UPDATE tblContacts SET mail1 = '4,5,6,' & mail1
  3. jonkovach

    Query to add text to data field

    Yes, I did.
  4. jonkovach

    Query to add text to data field

    Got it to work!!! However, one last glitch.... it doesn't put commas, just the numbers.... so instead of 3,5,7.... it's 357
  5. jonkovach

    Query to add text to data field

    Where do I put that in? In the "Update to:" field? I tried that, and couldn't get it to work. Do I need to replace "ThisField" with the Field name in my database? I tried that, too, and didn't get any results. I'm sorry I'm pretty slow with this.
  6. jonkovach

    Query to add text to data field

    Well, I am a novice at Access. But I've tried to put in [mailid] & "3".... and the like. That's all I can think of. I am pretty sure the database is set up correctly - I had someone else set it up. It's a very, very basic database. What it is, is just an organizational tool for my mailing...
  7. jonkovach

    Query to add text to data field

    I have a number field, and I just want to run an update query to add numbers to that field... i.e. it's 8 now, I want it to be 3, 5, 8. I can't figure out how to do that? Any help is appreciated! Thanks, Jon

Part and Inventory Search

Back
Top