Fix Microsoft Access INSERT Query Showing Expr Fields
Question details
Insert a new record into the Individual table instead of displaying values in Expr fields.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user is creating an INSERT query to add an individual to a table.
- Observed behavior
- The query displays values under Expr1000, Expr1001, and similar field names instead of adding a record.
Open the Individual table in Design View and check its field names and data types. Confirm whether IndividualID is an AutoNumber field and whether any other fields require values.
Specify Destination Fields and Run the INSERT Query
Use an explicit field list to map each value to the intended column, then run the query as an append operation.
In Access, select Create > Query Design, then switch to SQL View.
Replace the query text with: INSERT INTO Individual (IndividualID, FirstName, LastName, UserName) VALUES (6, "Benny", "Hill", "hillbenny"); Adjust the field names and values to match your table.
Select Run on the query design ribbon and confirm the append prompt if Access displays one.
Open the Individual table from the Navigation Pane and look for the new record. Refresh or reopen the table if it was already open.

Work With Office Documents and Tables in WPS Office
WPS Office is a free, lightweight alternative for documents, spreadsheets, and presentations. Its familiar interface and support for Microsoft Office formats make it easy to move everyday files, although it does not fix or run Access database queries.

Frequently Asked Questions
Why does Access show Expr1000 and similar column names?
Access can assign Expr names to calculated or unnamed expressions in a query result. Check the statement in SQL View and make sure it is an INSERT INTO statement rather than a query that only displays the values.
How do I add a record if IndividualID is an AutoNumber field?
In SQL View, omit IndividualID and its value, for example: INSERT INTO Individual (FirstName, LastName, UserName) VALUES ("Benny", "Hill", "hillbenny"); Access will generate the ID.
What should I check if the append query reports an error?
Open the table in Design View and check that the field names, data types, required values, and unique-field constraints match the values in the INSERT statement.
Can WPS Office run an Access INSERT query?
No. Run the query in Microsoft Access using SQL View and the Run button. WPS Spreadsheets can work with tabular data, but it does not execute Access database queries.




