Question: Query 5 Create a query called Weight Loss that displays columns for each client's Last Name, First Name, Street Address, and Height and calculates values
Query 5 Create a query called Weight Loss that displays columns for each client's Last Name, First Name, Street Address, and Height and calculates values in the Weight Loss column. To calculate weight loss, you must first create a query that lists each client's most recent weight from the bimonthly assessment. Using that query ealculate the difference in weight in a new query. Ensure that your calculated field is properly formatted. Your output should resemble the format shown in Figure 3-8, but the data will be different. Weight Loss Street Address . Height 1203 Green Avenue 5'10 1565 Fleming Street 6'0 1514 Irving Road 176 Walkers Ridge Way 5'7 2688 Private Lane 1394 Quiet Valley Lane 5'11" 2548 University Street 5'3 Last Name . : First Name . . Weight Loss . Pat Downey Prater JohnsonKathy Albert Kevin 5' 10 5'3" Tina Ray Moody Clark Dolloff Decker Sonya Marietta 985 Ridenour Street 5'1 2833 Fincham Road 5'2 4908 Oak Ridge Drive5'5 Lela URE 3-8 Weight Loss query
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
