Hi trying to work out a few issue(s)

My report is wanting to look for an activity that is in a group of app dates for under one customer

this customer may have a group of 1 - 40 appointments but needs to contain a specific (range of 4-5) activity.

What is the best way to do this a sub report looking for this activity ?

thanks

Philippe

Thank you for the reply
Sorry for the confusion
The idea is a customer can come in 30-40 times and want to search that there is an activity associated to that customer. The customer may or may not have that activity which I want to highlight. I have a status that is looking at the appointments as a base so I’m searching on date range with that status but need to see if that group of appointments contain that activity. The hard part is that the customer may have 2+ groups of appointments which may or may not have activity.
I have created a sub report to search on that activity which works well but as above brings in multiple activities that may or may not be right … is there a way to limit the date range from the parameter to the sub report say <2 and >2 months so it can exclude / include the activity ?
Thanks
Philippe

Thank you i have skipped the sub report, and used what you suggested which works well

I was over thinking everything !!

Regards

Philippe