Write a query to obtain the correct result

Reference no: EM13720549

Please write the right solution of the following question

Question- Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. The user should be prompted to Enter Minimum Loan Amount. The query should display all results that greater than or equal to the threshold. Run the query. Enter 400000 when prompted to Enter Minimum Loan Amount. You should have two results. Save and close the query.

Part 1- How to enter this in the criteria to obtain the correct result?

I need experts help to write a query for the above question.

Reference no: EM13720549

Questions Cloud

Determine the recommendations to ensure supply of nurses : In view of a national nursing shortage and inadequate numbers of nursing faculty for increasing enrollments, determine the recommendations would you make to ensure an adequate supply of nurses in your organization.

Business process approach to internal auditing : Identify four key activities/processes involved in the operations of the Commission (there are more than four). Prioritize them in terms of significance to the Board's operations

Define what are the major differentiation strategies : What are the major differentiation strategies followed by global, international, multinational and multi-domestic companies for operations management areas. Please indicate these from low to high levels for cost reduction and response time in diff..

Explain the types of information and data : Describe the types of information and data that supply management may share with different internal and external functions.

Write a query to obtain the correct result : Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. How to enter this in the criteria to obtain the correct result?

What organ synthesizes new erythrocytes : Where does ADH act in the kidneys, and what does it do and what is the baroreceptor reflex - what organ synthesizes new erythrocytes and thrombocytes? Does warfarin affect thrombocytes or not?

Strategic planning phase of project : It is now time to begin the strategic planning phase of your project. You have been hired as a consultant to help MovieFlix solve a business problem. You've previously described to MovieFlix's leadership the first step to helping them solve their ..

Explain the benefits and drawbacks of a global strategy : Examine the benefits and drawbacks of a global strategy versus those of a local strategy. Provide one example of when a global company would select a global strategy and one example of when it would select a local strategy.

Write a matlab function for given question : Write a Matlab function z=addIntegerBase(x,y,z) where x and y are positive integer where each integer is represented as an array of its coefficient in base b.

User Account

All Pages