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 Mike Lewis 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. dwapachee

    Splitting info from 1 cell into 2 cells in ACCESS

    Yes, I did do both first, I backed it up and I had created 2 new fields, one called Last Name and one called First Name. I copied and pasted your code in your post and that is the result I received. Not sure what happened there..... Danielle
  2. dwapachee

    Splitting info from 1 cell into 2 cells in ACCESS

    Hi, Thanks for that...I did what you said and it seemed to work, but when I ran it it asked me to "Enter Parameter Value" then it lists "Last Name" and below that is a text bos that I can enter in data, I left it blank and clicked ok and it said it could not update. Did I do something wrong...
  3. dwapachee

    Splitting info from 1 cell into 2 cells in ACCESS

    Hi Thanks for the info. Sorry but I am still a little stumped. I have not done an update query in quite a few years, and SQL has never been my strong point. Can you break it down a little for me, for clarity, I have put in the SQL view and added my actual field names (easier for me to read)...
  4. dwapachee

    Splitting info from 1 cell into 2 cells in ACCESS

    Hi, I have a table with just over 1000 records in it. In there I have a column that lists peoples names in this format: LASTNAME, Firstname I need to split this into 2 separate columns, one for the last name and one for the first name. The table that this information is in has around 25...

Part and Inventory Search

Back
Top