Here is another confusing situation for me. ...

[David_Hopkins]

Here is another confusing situation for me.

I have 2 tables, Students & Payments with a reference key of Name

I’m try to build a report template that will pull all Students and their payments for a certain year.

I want the report to look like this…

Name 1

payment 1 - date

payment 2 - date

payment 3 - date

Name 2

payment 1 - date

payment 2 - date

payment 3 - date

Name 3

payment 1 - date

payment 2 - date

payment 3 - date

I’ve built something like this… but it’s not working.

<<Start: OrderBy(SELECT(Students[Name], [Status]=“Active”), [Name])>>

[Name]

<<Start: OrderBy(SELECT(Payments[Name], AND([Name]=Students[Name], Year([Date])=Year(Today())) ), [Date])>>

[Payment] - [Date]

<> <>

I’ve also tried to use Payments as the primary and nest the call for student info … but that also didnt work right.

Does someone have an example of this?

or suggestion?

Thanks again…