View Single Post
  #1  
Old April 26th, 2010, 08:06 PM posted to microsoft.public.access.reports
JR Hester
external usenet poster
 
Posts: 375
Default Report combiones all records

Access 2007 on WinXP

Report creted based on query:
SELECT tblParticipantTrx.EmpID, tblSessions.StrtDate, tblSessions.StartTime,
tblClasses.ClassName, tblParticipants.EmpFname, tblParticipants.EmpLname,
tblSessions.MaxParticipants
FROM (tblClasses INNER JOIN tblSessions ON tblClasses.ClassID =
tblSessions.ClassID) INNER JOIN (tblParticipants INNER JOIN tblParticipantTrx
ON tblParticipants.EmpID = tblParticipantTrx.EmpID) ON tblSessions.SessionID
= tblParticipantTrx.SessionID
WHERE (((tblSessions.StrtDate) Between [Begin] And [end]))
ORDER BY tblSessions.StrtDate, tblSessions.StartTime;

My problem is that I have more than one session on some strtdate's. I want
the report to give totals only for each session. I can't seem to find teh
right procedural syntax get this result. I keep getting totlas for a complete
day, whcih appear to be correct.

Since my query has both a strtdate and starttime, isn't there some way to
instruct the report to generate totals based on the combination of the
strtdate adn starttime.

Admittedly, I do use the report wizard method of report generation as
opposed coding!