Im using Microsft Access to Create this query. Thank you. Show transcribed image
ID: 3910046 • Letter: I
Question
Im using Microsft Access to Create this query. Thank you.
Show transcribed image text
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 Report 1 Create a report called Volunteer Awards. First create a query that shows the last and first names of volunteers, their length of service, and their award. The Length as a Volunteer field is a calculated field in the query, and the Award field requires an IF statement. Use the following rule: If volunteers have more than seven years of service, they receive a gold pen. Otherwise, they get a silver pen. Save the query as Volunteer Awards, and then bring the query into a report with the same title. Your data will differ, but the output should resemble that in Figure 5-9 Volunteer Awards Volunteer Awards First Name Award Gold Pen Gold Pen Gold Pen Gold Pen Gold Pen Silver Pen Silver Pen Silver Pen Silver Pen Silver Pen Last Name Webster Luke Ward Meartz Maria Luis Seever Seals Doorey Patt Leon FIGURE 5-9 Volunteer Awards reportExplanation / Answer
If you have any doubts, please give me comment...
SELECT [Last Name], [First Name], iif(DATEDIFF("yyyy", [Start Date], Date())>7, "Gold Pen", "Silver Pen") AS Award
FROM Volunteers V
ORDER BY [Start Date];