Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
hy is my qryLevelParameter  query coming up blank?? Create a new parameter query in Design View based on the tblStates table and the tblSessions table as described below: Add the StateName field from the tblStates table to the query. After the StateName field, add the SessionName, SessionLocation, and Level fields (in that order) from the tblSessions table to the query. Enter a parameter criterion associated with the Level field that uses the following prompt text: “Type Primary, Intermediate, or Senior” Run the query, enter Primary when prompted, and then confirm that 17 records are returned.

hy is my qryLevelParameter  query coming up blank?? Create a new parameter query in Design View based on the tblStates table and the tblSessions table as described below: Add the StateName field from the tblStates table to the query. After the StateName field, add the SessionName, SessionLocation, and Level fields (in that order) from the tblSessions table to the query. Enter a parameter criterion associated with the Level field that uses the following prompt text: “Type Primary, Intermediate, or Senior” Run the query, enter Primary when prompted, and then confirm that 17 records are returned.

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter3: Creating Tables
Section: Chapter Questions
Problem 7SCG: The SERVICE_REQUEST table uses the CHAR data type for the DESCRIPTION and STATUS fields. Is there an...
See similar textbooks
icon
Related questions
icon
Concept explainers
Question

why is my qryLevelParameter  query coming up blank??

  1. Create a new parameter query in Design View based on the tblStates table and the tblSessions table as described below:
  2. Add the StateName field from the tblStates table to the query.
  3. After the StateName field, add the SessionName, SessionLocation, and Level fields (in that order) from the tblSessions table to the query.
  4. Enter a parameter criterion associated with the Level field that uses the following prompt text:

“Type Primary, Intermediate, or Senior”

  1. Run the query, enter Primary when prompted, and then confirm that 17 records are returned.
7. a. b. C. d. e. Create a new parameter query in Design View based on the tb/States table and the tblSessions table as described below: Add the StateName field from the tb/States table to the query. After the StateName field, add the SessionName, Session Location, and Level fields (in that order) from the tb/Sessions table to the query. Enter a parameter criterion associated with the Level field that uses the following prompt text: "Type Primary, Intermediate, or Senior" Run the query, enter Primary when prompted, and then confirm that 17 records are returned.
Transcribed Image Text:7. a. b. C. d. e. Create a new parameter query in Design View based on the tb/States table and the tblSessions table as described below: Add the StateName field from the tb/States table to the query. After the StateName field, add the SessionName, Session Location, and Level fields (in that order) from the tb/Sessions table to the query. Enter a parameter criterion associated with the Level field that uses the following prompt text: "Type Primary, Intermediate, or Senior" Run the query, enter Primary when prompted, and then confirm that 17 records are returned.
AB File Home Create View Views Tables +++++++ O O O O O P Clipboard All Access Obje... < Search... tblSessions tblStates Queries GradingInfo Table tblClients tblSubjectTypes tblTutors Ready Paste qryCTME Forms qryLevelParameter qryStatesAndSessions qryTutorBonus qryTutorRevenue Cut LE Copy qryTutorRevenueSummary qryTutorsAndSessions frmSessionInfo frmClientsSearchContact frmSessionsMaster Reports ✓ frmTutorsAndSessions frmTutorSearch frmTutorSummary rptRevenue NP_AC16_CS5-8a_Raven MarieJones_1: Database- C:\Users\Owner\Downloads\NP_AC16_CS5-8a_Raven MarieJones_1.accdb (Access 2007 - 2016 file format) - Access Format Painter External Data Database Tools Help Ascending Descending Remove Sort Sort & Filter Fy Filter Query1 X StateName Record: K < 1 of 1 Tell me what you want to do Selection Advanced Toggle Filter SessionName Refresh All New Save X Delete No Filter Search Records Session Location Σ Totals abc Spelling More ✓ Level Find Replace → Go To Select Find Calibri B I U A 11 24₂ Text Formatting V >¶ A Marie Jones MJ Num Lock RHA Ō SQL X
Transcribed Image Text:AB File Home Create View Views Tables +++++++ O O O O O P Clipboard All Access Obje... < Search... tblSessions tblStates Queries GradingInfo Table tblClients tblSubjectTypes tblTutors Ready Paste qryCTME Forms qryLevelParameter qryStatesAndSessions qryTutorBonus qryTutorRevenue Cut LE Copy qryTutorRevenueSummary qryTutorsAndSessions frmSessionInfo frmClientsSearchContact frmSessionsMaster Reports ✓ frmTutorsAndSessions frmTutorSearch frmTutorSummary rptRevenue NP_AC16_CS5-8a_Raven MarieJones_1: Database- C:\Users\Owner\Downloads\NP_AC16_CS5-8a_Raven MarieJones_1.accdb (Access 2007 - 2016 file format) - Access Format Painter External Data Database Tools Help Ascending Descending Remove Sort Sort & Filter Fy Filter Query1 X StateName Record: K < 1 of 1 Tell me what you want to do Selection Advanced Toggle Filter SessionName Refresh All New Save X Delete No Filter Search Records Session Location Σ Totals abc Spelling More ✓ Level Find Replace → Go To Select Find Calibri B I U A 11 24₂ Text Formatting V >¶ A Marie Jones MJ Num Lock RHA Ō SQL X
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

When I remove the quotations it says Invalid string a string can have up 2048 characters

File Home Create External Data Database Tools View Tables Results All Access Obje... < Search... + + + + + 68 国国国国国 GradingInfo Table tblClients tblSessions tblStates Queries tblSubjectTypes Run Select Make Append Update Crosstab Delete Table tblTutors qryCTME qryLevelParameter qryStatesAndSessions qryTutorBonus qryTutorRevenue Forms qryTutorRevenueSummary qryTutorsAndSessions frmClientsSearchContact frmSessionInfo frmSessionsMaster frmTutorsAndSessions frmTutorSearch frmTutorSummary Reports NP_AC16_CS5-8a_Raven MarieJones_1: Database- C:\Users\Owner\Downloads\NP_AC16_CS5-8a_Raven MarieJones_1.accdb (Access 2007 - 2016 file format) - Access rptRevenue Ready Query Type qryLevelParameter X Field: StateName Table: tblStates Sort: Show: Criteria: [Enter State Name:] or: Help Query Design Union Pass-Through Data Definition SessionName tblSessions Add Tables Tell me what you want to do ← Insert Rows x Delete Rows Builder Microsoft Access SessionLocation tblSessions LIJ Insert Columns LIIJ Delete Columns Return: All Query Setup Level tblSessions tblStates ermediat Or "Senior State StateName Σ Totals Parameters OK Property Sheet Table Names The expression you entered has an invalid string. i A string can be up to 2048 characters long, including opening and closing quotation marks. Show/Hide 00 X tb|Sessions JESSIOTIVALITTe SessionLocation State Duration MaxSize TutorID Subject Level Semester Marie Jones x MJ Add Tables Tables Links Queries Search GradingInfo Table tblClients tblSessions tblStates tblSubjectTypes tblTutors Add Selected Tables Num Lock All SQL X X
Transcribed Image Text:File Home Create External Data Database Tools View Tables Results All Access Obje... < Search... + + + + + 68 国国国国国 GradingInfo Table tblClients tblSessions tblStates Queries tblSubjectTypes Run Select Make Append Update Crosstab Delete Table tblTutors qryCTME qryLevelParameter qryStatesAndSessions qryTutorBonus qryTutorRevenue Forms qryTutorRevenueSummary qryTutorsAndSessions frmClientsSearchContact frmSessionInfo frmSessionsMaster frmTutorsAndSessions frmTutorSearch frmTutorSummary Reports NP_AC16_CS5-8a_Raven MarieJones_1: Database- C:\Users\Owner\Downloads\NP_AC16_CS5-8a_Raven MarieJones_1.accdb (Access 2007 - 2016 file format) - Access rptRevenue Ready Query Type qryLevelParameter X Field: StateName Table: tblStates Sort: Show: Criteria: [Enter State Name:] or: Help Query Design Union Pass-Through Data Definition SessionName tblSessions Add Tables Tell me what you want to do ← Insert Rows x Delete Rows Builder Microsoft Access SessionLocation tblSessions LIJ Insert Columns LIIJ Delete Columns Return: All Query Setup Level tblSessions tblStates ermediat Or "Senior State StateName Σ Totals Parameters OK Property Sheet Table Names The expression you entered has an invalid string. i A string can be up to 2048 characters long, including opening and closing quotation marks. Show/Hide 00 X tb|Sessions JESSIOTIVALITTe SessionLocation State Duration MaxSize TutorID Subject Level Semester Marie Jones x MJ Add Tables Tables Links Queries Search GradingInfo Table tblClients tblSessions tblStates tblSubjectTypes tblTutors Add Selected Tables Num Lock All SQL X X
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS