Exclude Calculated Fields from an Access Make-Table Query
Question details
The user needs to create an Access table from selected source fields without copying calculated fields.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A Make-Table query uses SELECT * to copy fields from a source table that includes calculated columns.
- Observed behavior
- Access reports that a calculated column cannot be saved without a valid expression.
Identify the source fields the destination table needs, including any IDs used for joins. Check whether the destination table already exists: a Make-Table query can replace an existing table, while an Append query adds records to it.
Select only the required fields in the Make-Table query
Replace SELECT * with an explicit field list to leave calculated source fields out of the new table.
Access SQL does not provide a SELECT * syntax that excludes specific fields. List each field you want to copy, and calculate derived values in a separate query when needed.
In Access, right-click the Make-Table query in the Navigation Pane and choose SQL View.
Replace SELECT * with the required source fields. For example, use: SELECT Game_ID, Roster_ID, Player_ID INTO Game_Stats_Copy FROM Game_Stats; Add any required statistics to the field list and use your actual table and field names.
If the query filters for an exact Player_ID, use = rather than Like. For a numeric ID, an example is WHERE Player_ID = 22; for a text ID, use WHERE Player_ID = "22".
On the Query Design tab, click Run and review the destination table to confirm it contains the selected fields and records.
Append selected fields to an existing destination table
Use an Append query when the destination table already exists or you want to define its fields yourself.
Work with Office documents and spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for documents and spreadsheets, with a familiar interface and Microsoft Office format compatibility to help you migrate existing files. It does not fix Access queries or replace Access database functionality.

Frequently Asked Questions
Can I exclude a few fields while keeping SELECT * in Access?
Access does not support excluding named fields from SELECT *. In SQL View, replace the wildcard with a list of the fields you want in the destination table.
Do calculated values have to be stored in the new table?
No. You can omit the calculated fields from the Make-Table query and create expressions in a separate query when you need the values.
Should I use Like or = to filter a specific Player_ID?
Use = for an exact match. In SQL View, use a number without quotes for a numeric field, such as Player_ID = 22, or quotes for a text field, such as Player_ID = "22".
How do I add records without recreating the destination table?
Create an Append query in Query Design, select the existing destination table, and map the required source fields in the Append To row before clicking Run.




