G
Guest
I have been trying to set up a library database in access and have been
having some difficulty in concatenating authors names, when there is more
than one author (there may be up to four). My problem is I can't get rid of
the commas in the columns that do not contain more than one author. I have
searched the discussions here and have not come across this problem.
ie: Author1
Smith, John
ABC Press,
where ABC Press is the LastName
then when I combine Author1 & Author2 and Author2 is blank I have the same
problem.
I would like to be able to combine all four authors into one Authors column
with one query.
I'm sure there is a simple explanation, but it is eluding me.
having some difficulty in concatenating authors names, when there is more
than one author (there may be up to four). My problem is I can't get rid of
the commas in the columns that do not contain more than one author. I have
searched the discussions here and have not come across this problem.
ie: Author1
Smith, John
ABC Press,
where ABC Press is the LastName
then when I combine Author1 & Author2 and Author2 is blank I have the same
problem.
I would like to be able to combine all four authors into one Authors column
with one query.
I'm sure there is a simple explanation, but it is eluding me.