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.
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.