Microsoft Access Query Question

pts.
Tags:
Database
IBM DB2
Oracle
I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named "PapersPresented" I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make it readable when I run the Resume Report. Here is the break down of the Tables I am using to create the Query AuthorsTable AuthorKey AuthorName PapersPresentedTable PapersPresentedKey PaperName DateTO DateFROM FacultyKey PapersPresentedAuthorsTable AuthorsKey PapersPresentedKey LocationTable LocationKey LocationName PapersPresentedLocationTable PapersPresentedLocationKey LocationKey PapersPresentedKey Any Help Would be Greatly Appreciated. This is a database of Resumes from multiple people. I also have a question on how to create a report and pull the data for One Person, currently I can create a report that will generate all the Resumes for all the people. I want to be able to pick a persons name and create a resume for that person. Thanks for any help JohnB

Answer Wiki

Thanks. We'll let you know when a new response is added.

To show several authors for one paper you could group your report by paper. Place the paper in the group header and the author name in the group details. For your second question, you can pull in all resumes for one person by creating a report that utilizes a parameter. Ask for the name or id of the person in the parameter and filter your query that drives the report to pull back only records that match that id.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following