Hi Everyone,
I have this query to count how many support requests are made within a given date range:
I was hoping to get the data returned back something like follows:
VTR | Broken | 6/14 | 6/15 | Larry | 3
TV | Gone | 6/17 | 6/18 | Larry | 3
Spkr| Blown | 6/20 | 6/21 | Larry | 3
Mic | Broken | 6/15 | 6/16 | Tom | 1
Mic | Broken | 6/14 | 6/16 | Sarah | 2
Spkr| Blown | 6/15 | 6/16 | Sarah | 2
But what I am getting is more like:
VTR | Broken | 6/14 | 6/15 | Larry | 3
Mic | Broken | 6/15 | 6/16 | Tom | 1
Mic | Broken | 6/14 | 6/16 | Sarah | 2
I want to be able to loop through the records to create a master and detail levels in a report page I am working on. Is there a way I can get my records returned like the first example?
Thanks in advance,
Ken
I have this query to count how many support requests are made within a given date range:
SQL:
SELECT tblequipissues.EquipType, tblequipissues.Issue, tblequipissues.IssueDate, tblequipissues.FixedDate, tblequipissues.EnteredBy, COUNT(tblequipissues.EnteredBy)
FROM tblequipissues
WHERE IssueDate >= StartDate AND IssueDate <= EndDate AND SendTo LIKE SentTo
GROUP BY tblequipissues.EnteredBy
ORDER BY tblequipissues.IssueDate
I was hoping to get the data returned back something like follows:
VTR | Broken | 6/14 | 6/15 | Larry | 3
TV | Gone | 6/17 | 6/18 | Larry | 3
Spkr| Blown | 6/20 | 6/21 | Larry | 3
Mic | Broken | 6/15 | 6/16 | Tom | 1
Mic | Broken | 6/14 | 6/16 | Sarah | 2
Spkr| Blown | 6/15 | 6/16 | Sarah | 2
But what I am getting is more like:
VTR | Broken | 6/14 | 6/15 | Larry | 3
Mic | Broken | 6/15 | 6/16 | Tom | 1
Mic | Broken | 6/14 | 6/16 | Sarah | 2
I want to be able to loop through the records to create a master and detail levels in a report page I am working on. Is there a way I can get my records returned like the first example?
Thanks in advance,
Ken