A records not updating
To see the criteria, if any, for selecting records for the bulk operation, see the Criteria and the or row, and any additional rows below the or row that display selection criteria.If these rows are empty, all rows in the table listed in the Table row will be updated.Future articles will consider cases where more than one table may be involved.
You may also look at the SQL View of the query which is shown in the next paragraph.Test Product Qry The above query was run which created the Test Products table.After the table was created a primary key was added so that a form and data access page based update can be described. If you right click the little black rectangle at the top left corner, you can access the form’s properties as shown.These queries can be created using the query designer tool.Creating an update query using the designer is really very simple. Right click the border between the design and grid to pop open the window with several menu items as shown. The grid changes somewhat, allowing to choose which column or columns you need in the table, and showing you where you can type in the changes as shown.