Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a new parameter query in Design View based on the Consultant table with the following details: Add the ConsultantID , FirstName , LastName ,

  1. Create a new parameter query in Design View based on the Consultant table with the following details:
    1. Add the ConsultantID, FirstName, LastName, and Reside fields to the query grid in that order.
    2. Right-click the LastName criteria box, and then open the zoom dialog box. Enter the following in the zoom dialog box: Like [Enter Consultant Last Name] & "*"
    3. i get an error code saying the expression you entered contains invalid syntax, you may have entered a comma without a preceding value or identifier

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Horse Betting The Road To Absolute Horse Racing 2

Authors: NAKAGAWA,YUKIO

1st Edition

B0CFZN219G, 979-8856410593

More Books

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago