Report and Unbound Text Box

[JMZ]

My report shows the number of times I've placed 1st, 2nd and 3rd place and the name of my partner.
What I'm trying to do is add an unbound text box to show how many time we have partnered up together.
ex.
3rd place Nov.24 John Smith
Partnered up "6" times before
My query qPlace brings in all my data from tSchedule, I want to add a text box that will count the number of times that partner appears in tSchedule.

 

[Pat Hartman]

We need to see the schema and sample data wouldn't hurt.

 

[June7]

Could build an aggregate query to count each competitor's appearances in tSchedule then include that query in qPlace.
Or use DCount() expression.

 

[JMZ]

DCount works but it counts all partners as a total.

 

[Pat Hartman]

DCount works but it counts all partners as a total.

The dCount needs criteria.

 

[JMZ]

I did the aggregate query and it shows exactly what I want
ex.
1st place on November 24, 2024 with John Smith and we matched up 6 times.
How do I get the 6 to show up in the unbound text box.

 

[theDBguy]

I did the aggregate query and it shows exactly what I want
ex.
1st place on November 24, 2024 with John Smith and we matched up 6 times.
How do I get the 6 to show up in the unbound text box.

If you have the values in the source query, couldn't you now use a bound textbox instead?

 

[June7]

As I said, include aggregate query in qPlace query. Join on partner ID. Bind textbox to field.

 

[JMZ]

The aggregate query works I didn't add the new field to my report and kept trying =DLookup in the control source on properties.
It all came together.
Thank you for helping.