Help, how do I merge...

C

Catherine C

I've posted before but I think I need to be more explicit. I have a book
database. It includes a book table which lists all the titles, an author
table with all the authors and then a join table which has a bookauthorID
(the key), BookID (relates to book table), and AuthorID (relates to author
table). When I try to run a report from the query, it shows some titles
twice since they have different authors (both authors wrote the book). Is
there a way to join the authors so they both display once with the title?
(Also, the concatenate function is not working). Thank you
 
D

Duane Hookom

Answered in your previous thread which was a fresh as last night. Please be
patient and wait for responses in existing threads. There should be no
reason to start a new thread with the same question with the same 24 hour
period.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top