Ms access update query not updating table dating text messages

Posted by / 26-Nov-2015 09:05

Ms access update query not updating table

A “Make Table” query creates a new table as the output of a query, instead of simply displaying a query result set.

This new permanent table can be useful in a variety of ways: you could use it as a basis for other queries; it could serve to backup important data; or it could show selected information from multiple underlying tables in a single table which you could then export to Microsoft Excel for spreadsheet-style analysis.

Since the basis of the make table query is a standard ‘select’ query-type, you can restrict the columns and rows that are displayed in the new table by picking just the fields you wish to view and applying query criteria.

The fields that comprise the new table created from the make table query’s result set retain the data type and field size properties that were assigned to the original fields.

To create a make table query, first create a standard query in design view.

Select only the fields that you want to include in your new table, and use criteria to restrict the rows selected, if needed.

In Access, that is exactly what the “Make Table” queries do.

When you have selected where to place the new table, click “OK” in the “Make Table” dialog box.

You can also select whether to place the new table into the current database, or into another database by selecting the desired option button.

If you select “Another Database:,” then you will have to click the “Browse…” button and use the dialog box that appears to select the database file into which you want to place the new table.

Then click the “Make Table” button in the “Query Type” group of the “Design” tab in the “Query Tools” contextual tab in the Ribbon to change the query type.

ms access update query not updating table-59ms access update query not updating table-40ms access update query not updating table-74

In the “Make Table” dialog box that appears, you can type a name for the new table that will be created when you run the query.