Matt Miller owns a lawn and landscape business. He has some very particular clients who want their lawns manicured on a specific day of the week. He has other clients who allow him to use his own judgement as to when their lawns need cutting. To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision and fee. Matt creates a table called Customers. For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Matt wants to build a query that will show each customer name, day of the week (if specific), and subdivision. What criterion should he use to quickly find his customers whose day of the week varies?

Question

Quizplus · Accepted Answer

The Answer of Matt Miller owns a lawn and landscape business. He has some very particular clients who want their lawns manicured on a specific day of the week. He has other clients who allow him to use his own judgement as to when their lawns need cutting. To maximize his efficiency, he wants to build a query that will show his weekly customers by name, day of the week, subdivision and fee. Matt creates a table called Customers. For those customers whose day of the week varies upon need, he leaves the day of the week field blank. Matt wants to build a query that will show each customer name, day of the week (if specific), and subdivision. What criterion should he use to quickly find his customers whose day of the week varies?

Matt Miller Owns a Lawn and Landscape Business