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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.