INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Record Select within a Group

Record Select within a Group

(OP)
I feel like there is an obvious solution that I am missing, and I am hoping someone can help me out of this Monday rut!

I have a report of donations to our organization for the year. I have the donations grouped by type and subtype, and I want to pull in the detailed donation information into each group. How Do I select specific records to be in each group? Right now they are grouping, but all gift detail is showing up in each section.

Example: Group cash gifts with subtype 'A' and 'C'-- all gift detail; group cash gifts with subtype 'B'-- all gift detail; group in-kind gifts-- all gift detail.

RE: Record Select within a Group

Not sure what you mean.
Are you saying that within Group A you are seeing details of sub type B?

If you are using more than one table you may have a cartesian join. ie you are relating all records from table 1 to all records in table 2.

Double check your table joins and make sure relationship is either one to one or one to many. I think you currently have many to many which is difficult if not impossible to build a report from

Ian

RE: Record Select within a Group

(OP)
It is a one to many table linking, but the type and sub-type options are in the same table.

RE: Record Select within a Group

If that is the case I can't see how you are getting all gift details showing against all records.

Please give an example of the data you have and how you want to see it.
Still looks like your give details are not linking correctly.

Ian

RE: Record Select within a Group

(OP)
I've been able to get what I needed with subreports.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close