Access queries / reports

pts.
Tags:
Development
I am working on a report that I need a little help with. I am not a programer so I tend to use simple queries to do all of my work. Here is the situation. I have a db that has several tables, but the info that I need is primarily in just 2 tables. Client - has all the client info such as addresses client numbers Services - has a discripition of the services that are provided. I can run a query promptinng the user for a client number and it returns all the services, however it also returns the client number with each service. 888888 - Address - service1 888888 - Address - service2 In my report I only want the client info once, and I need all the services to show up a well. How can I do this ??? Thank you for your help.

Answer Wiki

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

I assume you are creating an MS Access report.

You have the data you want. You need to create a group on the client number.

Select the detail section of the report design, click right mouse, and pick “sorting and grouping”. In the field or expression column, select the client number field. For group header, say yes. Close the dialog. Move the client number (and related fields) to the new group header section.

By the way: MS Access installs with a sample database: Northwind.mdb. This should get your creative juices flowing.

Discuss This Question: 2  Replies

 
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
  • Ahardyb5
    Note - if tables related (i.e., relationship defined in database between selected fields in the two tables), the grouping and sorting and desired layout/format occur by default, if report is gen via Report Wizard. And don't have to perform the steps to "program" the report in Designer (find detail section, click right mouse, pick sorting and grouping, etc.). AH Bost
    0 pointsBadges:
    report
  • Weiglek
    Alternately, set the Hide Duplicates property to Yes on the report field for client number.
    0 pointsBadges:
    report

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