Problem is we need to have a better overview of this table 'tbl_MailAdr'.
We have there various email addresses in one column seperated by ';' sometimes there are unneeded spaces inbetween as well " ".
Here the two tables. (I created the second one. From that one we can put with queries the data there together.)
Group: Number, Primary key
Name: Text, Primary key
Company: Number, Primary Key
Description what is needed:
Count: AutoNumber, Primary key
This 'tbl_MailAdr' lies on a sql server. It is prefered that we get a solution for MS Access 2003.
I need a process where we copy all data lines from tbl_MailAdr to tbl_MailAdr_single.
In the field
there could be either no data in it, one email without any ';' in the end or more then 20 email addresses with ';' in it and sometimes with ' ' in it.
What needs to be automatically processed is copy the data from tbl_MailAdr to tbl_MailAdr_single and create for each line the same data however, with a the seperated email addresses AND a different count (auto)number.
If the process contains a delete 'tbl_MailAdr_single' before processing would be ideal but is not needed since that is fast done by hand or a delete query.