Search results

thank you. Again...perfect. Went from a 3 hour job to a 3 minute one. Much appreciated. Jim

thank you...perfect. Now, I discovered there's some middle initials in the first name, is there a way to strip everything from the right away? Up to the first blank? Jim

As I stated, I don't know how or where to put that type of code. I've only used the query expression builder up to this point. If those things work, I unfortunately need specific instructions on how to use that code. Jim

I have a database with two fields for emailing. Firstname and Email. I want to run a query to capitalize just the first character of the Firstname field. I figured out how to change the field to lowercase but that's it. Now I need the first character changed to upper case. I only know how to...

thank you

Hi, I have a table that has a lastname field in it that contains firstname space and lastname. I also have a firstname field. I need to split that lastname field into the firstname and lastname fields. I have no idea how to do this. I can create basic queries, I've done update ones, and a...