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!

Recent content by Prunes

  1. Prunes

    Access Report

    Sorry for the frustration. It's just that I am a real novice at Access. Just starting to learn the app. I appreciate all the help. Will let you know if I get it working. [bigglasses]
  2. Prunes

    Access Report

    Now the problem I have is that the names were listed LastName, FirstName like in the example I gave above. How do I switch the names around? Example: This is what I am getting with the code Goldstein, Leigh Ann ===> G. Leigh Ann Gacina, Marleena ===> G. Marleena O'ndiek, Paulo S. ===>...
  3. Prunes

    Access Report

    The name field has names that have middle initials as well as middle names and some do not have middle initial nor middle names. I found the database already made and I am still learning the application. Here is a sample of how the names are listed in the table: Goldstein, Leigh Ann Gacina...
  4. Prunes

    Access Report

    Thanks for your lightening speedy response. To answer your questions: 1.Are all of your name fields used consistently in every one of your records? = Yes 2.Are there any middle initials? = yes 3. How about first names that contain a space? = yes (Leigh Ann)
  5. Prunes

    Access Report

    Hello Friends, I need some help. Does anyone know how to convert a full name eg John Doe to J. Doe,. I am working on a report that needs to generate a letter with a Dear J.Doe but I don't know how to do this. The query is based on one table with one name field. This is MS Access 2003 Prunes
See more

Part and Inventory Search

Back
Top