Open the Drivers report in in Design View (I did) Modify the record sourc of the

Question

Open the Drivers report in in Design View (I did) Modify the record sourc of the report using SQL statement to select all Drivers record with Class of Adult. My Sql statement was: SELECT* FROM Drivers WHERE (((Class)="Adult"))
Home Format External Data Database Tools Arrange Format Page setup 9 T me what you want to do Aa L colors. ab Aa View Themes A Fonts Hide Details "mane Numbers Date and Time Grouping a Totals Header Footer All Access Obje... Dnvers Property Sheet Ageno info Drivers. Microsoft Access Data Levent l other l The record source sELECr WHERE (eaasd- Adult specified on this form or report does not exist. The name of the recordsource may be misspelled the recordsou or renamed, or the recordsource exists in a different database. deleted In the Form or Report's Design view or Layout view, display the pr sheet bydicking the Properties button and then set the Recordsource property to an table or quen. ned Insurance Group, Sort, and Total w Navigator Reports la Drivers Ad Insurance subreport D: Add a group Add a sort

Explanation / Answer

Your query was correct.. but no need of putting too many braces on WHERE clause..

SELECT* FROM Drivers WHERE Class="Adult";

This query will select all drivers having class as adult

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.