Add criteria to this query to return only the records where the value in the SubscriptionType field is Self or Family and the va

Question

artcher [175]

1 year ago

12

Add criteria to this query to return only the records where the value in the SubscriptionType field is Self or Family and the va

lue in the Premium field is <200. Run the query to view the results.

Computers and Technology

1 answer:

miss Akunina [59] · Answer 1 · 2024-03-11T11:11:46+03:00

Click Run in the Results group under the Design tab. Only show records in the search results that have a Credits field value greater than 120. To see the results, run the query. Click the criterion row for the Credits field and enter >120.

<h3>The meaning of the criterion =200</h3>

Equal to or less than 200. To compute statistics like Sum, Average, or Count, add a Total row to the query datasheet.

<h3>How may criteria be set in an Access query?</h3>

Open the query in Design view and choose the fields (columns) you want to set criteria for in order to add criteria to an Access query. Double-click the field to add it to the design grid if it isn't already there.

To know more about criterion row visit:-

brainly.com/question/7301380

#SPJ4