Updating a query in ms access
If you place one set of criteria on the Criteria line and the second set of criteria on the Or line, Access will retrieve records if either criteria are met.For example, you want all records where the State is equal to "DE" the Last Name is equal to Smith.You can use a query to view a subset of your data or to answer questions about your data.For example, if you want to view a list of student names and email addresses, but you do not want to see addresses and other data, you can create a query that displays the student’s first name, last name, and email address only.
Click anywhere in the row you want to delete and then click the Delete Row button. Click anywhere in the column you want to delete and then click the Delete Column button . This is useful when you want to create a new table that includes the fields and data from an existing table.Use the Insert Rows button to insert a row in the criteria area.Click anywhere in the row before which you want to insert a new row and then click the Insert Rows button. Click anywhere in the column before which you want to insert a column and then click the Insert Column button .The tables and queries from which you pull your data should have a relationship.Tip: You can also save by right-clicking a query’s tab and then selecting Save from the menu that appears.You would set the State field to = "DE" and the Last Name field to = "Smith" and you would place one set of criteria on the Criteria line and the other set of criteria on the Or line.Access will bring back all records where the state equals DE If you want to view data from two or more tables or queries, you can create a query that pulls the data from multiple tables or queries.You specify the sort in the order you want the sort to occur.If you want to sort by state and then by last name within a state and then by first name within last name, you enter the sort in the following order: city, last name, first name.You use logical operators such as = (equal), When using the Like and Not Like criteria, where you place the asterisk(*) or question mark (? Like "Jo*" finds all records in the field that begin with . Like "*456*" finds all records that contain 456 anywhere in the field. If you place two criteria on the same line, Access will only retrieve records where both criteria are met.For example, if you want all records where the State is equal to "DE" the Last Name is equal to Smith, you would set the State field to = "DE" and the Last Name field to = "Smith" and you would place both criteria on the same line.