Question

Type an SQL statement into the Record Source property of the report. The statement should select all fields (*) for employees with the Sales Representative title.

Answer 1

Answer:

SQL statement into Record will be

SELECT * FROM Employee WHERE Employees.Title LIKE "Sales Representative " OR Employees.Title Like " Sale Manager

SELECT " FROM Employee WHERE Title =" Sale Representative and Title = " Sale Manager.

Explanation:

Like to do string comparisons have used and it is depend upon the database that are using.

If you are sure that title column has Title Representation and Sales Manager then you need to list the column and used single instead of double quotes and use OR instead of AND

if you are sure about Title column then use % match zero or more in the statement as well.