Re: access field that contains first name space last into separate fie

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Forgot to mention... This won't work very well if you have more than one
space in your Full Name field but it gets you started and you should be able
to refine the query from there.



Sheila wrote:
>How do I take a field in access that contains both first and last names of
>clients, and split them into two new fields, first name and last name?


--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Search a table by unsing a form
    ... My clients want the ability ... It is kind of like an and/or type of query but they need to be able to ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Query to search entire record, not one field?
    ... My clients want the ability ... It is kind of like an and/or type of query but they need to be able to ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Query Or Report?
    ... On Fri, 25 Nov 2005 15:46:24 GMT, Rick Brandt wrote: ... > "Clients" needs to the name of a table or query, ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Have a Problem With Fields Type Date in Queries
    ... Guys Need help with a query that i want to do, Im trying to make a query that ... In my table im putting all the instalation date ... of my clients and at the end of the day i only want to know which clients i ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: access field that contains first name space last into separate fie
    ... Now, if you have Tom Jones Jr, Last Name will be Jones Jr ... Sheila wrote: ... >clients, and split them into two new fields, first name and last name? ... Prev by Date: ...
    (microsoft.public.access.queries)