Hi there,
i really need help with this, so i dont know would this be more of access or excel question.
I have a table that i receive monthly, and i already import it to access, and from there to sharepoint; it has a lot of data, and the data changes a bit from month to month but not drastically.
now, in that table i have specific columns, ie.:
ID, Name, Rating, Date, Contact Info, City, State, NJ, Phone Number, E-mail, and so on...
now, i have to add extra two columns, to figure out which Function or Division they belong - which is mostly done using ID - which is i guess primary key - which btw, access doesnt let me to set it up as primary key.
So, i already made a first table with all those information above, and pluse two more columns, Division and Function, but instead of doing it manually, is there a way to do it automatically? Either through access or excel?
i really need help with this, so i dont know would this be more of access or excel question.
I have a table that i receive monthly, and i already import it to access, and from there to sharepoint; it has a lot of data, and the data changes a bit from month to month but not drastically.
now, in that table i have specific columns, ie.:
ID, Name, Rating, Date, Contact Info, City, State, NJ, Phone Number, E-mail, and so on...
now, i have to add extra two columns, to figure out which Function or Division they belong - which is mostly done using ID - which is i guess primary key - which btw, access doesnt let me to set it up as primary key.
So, i already made a first table with all those information above, and pluse two more columns, Division and Function, but instead of doing it manually, is there a way to do it automatically? Either through access or excel?