Question: Can someone please help me with this access query? Create a query called Walkers of Old Dogs that displays the full names of the walkers
Can someone please help me with this access query?
Create a query called Walkers of Old Dogs that displays the full names of the walkers and then lists the name of each dog they walk that is over 8 years old. This is a summary query with time calculations and critieria to filter out records. Note that the age field outputs are hidden. use date() functions to get the current date from the system. Divide the days by 365.25 to convert days to years.
Walker Requests Customer Dog 1 Oo Walker ID Last Name First Name Street Address Request ID Customer ID Walker ID Date Start Time Length Customer ID Last Name First Name Street Address Customer ID Dog ID Name Date of Birth Breed Weight Height State ZIP Home Phone Cell Phone Email Address Experience with large dogs? Insured/Bonded State Zip Home Phone Cell Phone Work Phone Email Address Credit Card Number Expiration Date CCV Code Lockbox Insured/Bonded
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
