What is the sql statement for this problem I'm using Access and have to write in record source in the property sheet I wrote SELECT FROM Employees, WHERE title 'Sales Representative' The above statement is not working Can someone please give a proper statement property box b Type an SOL statement into the Record Source property of the report The statement should select all fields for employees with the Sales Representative title Save the report c Test the report in Print Preview, and close the report

The Answer is in the image, click to view ...

Question: What is the sql statement for this problem. I'm using Access and have to write in record source in the property sheet. I wrote SELECT*

What is the sql statement for this problem. I'm using Access and have to write in record source in the property sheet.

I wrote SELECT* FROM Employees, WHERE title='Sales Representative';

The above statement is not working. Can someone please give a proper statement What is the sql statement for this problem. I'm using Access

property box. b. Type an SOL statement into the Record Source property of the report. The statement should select all fields for employees with the Sales Representative title. Save the report. c. Test the report in Print Preview, and close the report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

I've attached the assignment as a word file, thanks! JWCL165_c07_304-355.qxd 7/31/09 2:05 PM Page 304 7 Fraud, Internal Control, and Cash Chapter STUDY OBJECTIVES After studying this chapter, you...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

i need all Journal entries for chapter 4 only see the file Instructions City of Bingham Computerized Cumulative Problem For use with McGraw-Hill/Irwin Accounting for Governmental & Nonprofit Entities...

Your manager has provided you the following matrix and asked that you use it to complete the design assessment phase of your testing. The manager has already performed a preliminary survey, and has...

Nyeil, Inc., is a consumer products firm that is growing at a constant rate of 6.5 percent. The firms last dividend was $3.36. If the required rate of return is 18 percent, what is the market value...

ABC Inc. issued $1,000,000 of 8%, 5-year bonds at 97 on January 1, 2021. The straight-line method of amortization is used and the bonds pay interest annually on January 1. Journalize to record the...

What was the main argument of the speaker regarding Belle's story?

This period's WIP Ending Inventory becomes what in the following period? Cost of Goods Sold Finished Goods Beginning Inventory Cost of Goods Manufactured WIP Beginning Inventory

5. What decisions would a city manager at the postconventional level be expected to make?

7. What decisions would you make as the city manager?

4. What reaction would you expect of employees at the conventional level?