help with a code for separating lookup values from a table to display in a form

[AccessForumUser]

Hello, i'm new to access and am trying to figure out how i can split lookup values from a table to show individual results on a form.
I've made an example of what i'm trying to accomplish and was hoping someone could help me out with the code portion?



If you run the form and enter a value range of 2017-07-01 to 2017-07-31 it should come back with 6 results..
My question is, HOW do I show the individual results from the total?

I've played around with the IIF and Val commands with no success. help! Thanks..

[June7]

Don't think needs to be a Totals query.

Expression in the summary textbox can be simply: Count(*)

Expressions in other textboxes like: =Sum(IIf([PhoneType]="Broken",1,0)) or =Count(IIf([PhoneType]="Broken",1,Null))

I NEVER use dynamic parameterized queries. Too hard to validate user input. I prefer VBA code to construct criteria and apply to form Filter property. Review: http://allenbrowne.com/ser-62.html