I have to create a query from the inforamtion below then i have to create a repo

Question

I have to create a query from the inforamtion below then i have to create a report from that query. thank you for the help

Volunteer Hours Volunteer ID Date and Time Started Date and Time Ended S-101 1/2/2012 8:00:00 AM 1/2/2012 5:00:00 PM S-101 1/9/2012 12:00:00 PM 1/9/2012 10:00:00 PM S-101 1/10/2012 10:00:00 AM 1/10/2012 6:00:00 PM S-102 1/2/2012 4:00:00 PM 1/2/2012 10:00:00 PM S-102 1/10/2012 9:00:00 AM 1/10/2012 5:00:00 PM S-103 1/4/2012 9:00:00 AM 1/4/2012 8:00:00 PM S-104 1/8/2012 7:00:00 AM 1/8/2012 3:00:00 PM NGAGE Report 2 Create a seeond volunteer report that is based on a query. The query should list the last and first names of volunteers, the date and starting time for each day they volunteered, and the total hours worked each day. The Total Time field is a calculated field. Save the query as Volunteer January Hours. Group the report on Last Name, and then adjust the output so that the First Name is on the same line as the Last Name. Sum the total time worked by each volunteer. Your data will differ, but the output should resemble that in Figure 5-10. Give the report a title of Volunteer January Hours and save the report with the same name. All data and headings should be visible, as shown in Figure 5-10

Explanation / Answer

Select FIRSTNAME, LASTNAME, VT.DATEANDTIMESTARTED, VT.DATEANDTIMEENDED, DATEDIFF(MM,VT.DATEANDTIMEENDED,VT.DATEANDTIMESTARTED)

FROM VOLUNTEERS V

INNER JOIN VOLUNTEERSHOURS VT

ON V.VOLUNTEERID = VT.VOLUNTEERID

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---