Search results for query: *

Hi All, I have a table that has one field for contact names. I need to create a new table that splits that field into 3 (FirstName, MiddleIN, LastName). Some contacts have first name only, some have first name middle initial and last name and most have first and last name. How do I handle this?

Thanks for all the help. What I finally realized was that the existing ID numbers had to be taken into consideration. Once I adjusted the code to reflect them in each form it worked like a charm.

OK. I tried using both of these, but I couldn't figure out one part. You both include the word Purchasing and I can't figure out the eqivalent value in my application. Here's what I have: A form named Contacts. A field named ContactID. I want to use DMax to return an integer value. Please...

I'm terrible at writing expressions. I'm looking for a way to create a sequentially incrementing ID number in a form. I want to get a new sequential number every time I add a new record. I believe I can use the DMAX function, but I'm not sure how to word it.