K
kr
I have a database in which i import records from excel spreadsheet. once in
the database, i would like to assign the records to my employees -
automatically. I have 2 employees - John and Jane. I would like for John and
Jane's names to show up alternately for every record. Is there a way to
change the primary key to do this? I tried to come about it from update query
as well. i'm not that confident in vba and just looking to see if there is a
shorter way.
Thanks.
the database, i would like to assign the records to my employees -
automatically. I have 2 employees - John and Jane. I would like for John and
Jane's names to show up alternately for every record. Is there a way to
change the primary key to do this? I tried to come about it from update query
as well. i'm not that confident in vba and just looking to see if there is a
shorter way.
Thanks.