HomeworkLib
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

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

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
Volunteers
Volunteer ID Last Name First Name Address City State Zip Telephone Email Start Date
S-101 Burham Luke 212 Wedgewood Rd Kennett Square PA 19348 (610)292-1779 luke@course.com 12/1/1990
S-102 Doorey Leon 9 Sandelwood Dr Avondale PA 19311 (610)366-1929 leon@course.com 3/16/2010
S-103 Mattern Luis 205 Hanover Pl Avondale PA 19311 (610)366-0159 luis@course.com 4/2/2007
S-104 Seals Lauren 163 Darling Rd Kennett Square PA 19348 (610)369-9550 lauren@course.com 11/28/2009
S-105 Webster Sally 15 Anglin Dr Wilmington DE 19808 (302)738-5785 sally@course.com 7/11/1989
S-106 Ward Harry 11 Chapel Rd Wilmington DE 19808 (302)369-0643 harry@course.com 8/1/2000
S-107 Seever Patti 19 Danvers Circle Kennett Square PA 19348 (610)544-0923 patti@course.com 9/27/2009
S-108 Poplawski Meredith 281 Beverly Rd Elkton MD 21119 (410)433-0927 meredith@course.com 9/27/2009
S-109 Meartz Maria 511 Sparrow Ct Wilmington DE 19808 (302)655-1829 maria@course.com 11/1/2003
S-110 Lee Gregory 139 Boyer Way Avondale PA 19311 (610)655-0936 gregory@course.com 2/12/1999
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

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

0 0
Add a comment
Know the answer?
Add Answer to:
I have to create a query from the inforamtion below then i have to create a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Create a query in microsoft access  based on tblTransactions and tblProducts that calculates total sales volume for...

    Create a query in microsoft access  based on tblTransactions and tblProducts that calculates total sales volume for each ProductType during the first quarter of 2018. The query should calculate the total quantity of items sold by applying the Sum aggregate function to the Quantity field. Group the results by ProductType. tblTransactions 8/6/2019 ProductID TransID CustID RepID TransactionDate Quantity 12 Nguyen 13 Nguyen 14 1/1/2018 Jenkins Johnson 1/1/2018 17 3 20 Branson Jenkins 1/6/2018 7 9 1/6/2018 21 Peters Corez 12 Johnson...

  • 1. You are studying phage transduction and trying to deliver a kanamycin resistance gene from one...

    1. You are studying phage transduction and trying to deliver a kanamycin resistance gene from one strain of bacteria to another using phage. The kanR gene is FAR away from the lambda prophage in your bacterium. Choose which type of transduction should you use for your experiment and explain why. a. lambda phage, specialized transduction b. lambda phage, conjugation C. T4 phage, generalized transduction d. A different phage with mitomycin C induction 2. A pig is infected with two subtypes...

  • I am working on multi-table queries for my SQL class using a premade database, which I...

    I am working on multi-table queries for my SQL class using a premade database, which I have included screenshots of. I received assistance and was able to complete a good number of the queries but the bolded ones seem absolutely impossible to do?? How do I write a query for the bolded questions?? I've scoured my textbook and notes and cannot get anything I try to successfully produce results. 1. List all current reservations with the trip ID, customer’s first...

  • This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the...

    This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the business rules described below. Write all appropriate connectivities and cardinalities in the ERD. A music store would like to develop a database to manage information about the CDs, or vinyl collection, the customers and transactions information. It stores the relationships between artists, albums, tracks, customers and transactions. Here is the list of requirements for the database: The collection consists of albums. An album is...

  • I am currently facing a problem with my python program which i have pasted below where i have to design and implement python classes and record zoo database and takes user input as query. the error i...

    I am currently facing a problem with my python program which i have pasted below where i have to design and implement python classes and record zoo database and takes user input as query. the error i am recieving says that in line 61 list index is out of range. kindly someone help me with it as soon as possible. Below is the program kindly check and correct it. Thanks! class Animal: def __init__(self, name, types, species, mass): self.name=name self.type=types...

  • Query the apartment table and find nearby restaurants with in 200 meters distance. I have two...

    Query the apartment table and find nearby restaurants with in 200 meters distance. I have two tables one gives the home adressses and second has near by businesses with latitude and longitude given. I need to find restaurants nearby the adress with in 200 meters. Each business also has longitude/latitude information, we can get the database to calculate distances to various useful points close by to each apartment. So we have two tables 1. Apartments and no 2 is business....

  • These question is for mysql, so I want know what is answer that is information for...

    These question is for mysql, so I want know what is answer that is information for source: DROP DATABASE IF EXISTS travel; CREATE DATABASE travel; USE travel; -- -- Table structure for table `equipment` -- DROP TABLE IF EXISTS `equipment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `equipment` ( `EquipID` int(11) NOT NULL DEFAULT '0', `EquipmentName` varchar(50) NOT NULL DEFAULT '', `EquipmentDescription` varchar(100) NOT NULL DEFAULT '', `EquipmentCapacity` int(11) NOT NULL DEFAULT '0',...

  • What is the reaction mechanism of 2-Methyl-2-Butanol in H2SO4+Heat. I know the 2 products are 2-methyl-1-butene...

    What is the reaction mechanism of 2-Methyl-2-Butanol in H2SO4+Heat. I know the 2 products are 2-methyl-1-butene and 2-methyl-2-butene which product is the major product when its an acid-catalyzed dehydration reaction that was driven to completion by distillation? Also on my gas chromatography graph trace which product is which? Is the bigger peak my major product? I know I am looking at the peaks at 1.509 and 1.612. Thank you. : 10/24/2019 11:13:31 AM Injection Date Sample Name Acq. Operator Acq....

  • I need SQL query OrderlD, OrderDate, CustomerlD 1001 21/Oct/10,1 1002, 21/Oct/10,8 1003, '22/Oct/...

    Which orders have been placed since October 20, 2010? I need SQL query OrderlD, OrderDate, CustomerlD 1001 21/Oct/10,1 1002, 21/Oct/10,8 1003, '22/Oct/10, 15 1004, '22/Oct/10, 5 1005, 24/Oct/10, 3 1006, '24/Oct/10, 2 1007, '27/Oct/10,11 1008, 30/Oct/10, 12 1009, '05/Nov/10,4 1010, '0S/Nov/10 1 End Table, Cherry,175, 1 2 Coffee Table, Natural Ash: 200,2 3 Computer Desk, Natural Ash 3752 Natural Ash. 375 Entertainment Center Natural Maple,650, 3 Desk, 'white 6, '8-Drawer Ash, 750,2 7. Dining Tabla Natural Ash,800, 2 'Computer Desk,...

  • Hi i need Help. i use MYSQL command line. THE QUESTION ARE BELOW please check the...

    Hi i need Help. i use MYSQL command line. THE QUESTION ARE BELOW please check the answer before you submit because sometimes query gives error thank you For Full database of SQL you can DOWNLOAD from this link: https://drive.google.com/file/d/1xh1TcBfMtvKoxvJr7Csgnts68fF53Q1t/view?usp=sharing ------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- What are the total sales for each year. Note that you will need to use the YEAR function. Order by year with the newest year first. ------------------------------------------------------- How many employees have no customers? ------------------------------------------------------------------ List the total sales for...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT