Others

Fix Microsoft Access INSERT Query Showing Expr Fields

Camila MilosovichCamila Milosovich Nov 14, 2026 870 views

Question details

Insert a new record into the Individual table instead of displaying values in Expr fields.

Fix an Access INSERT Query That Shows 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.
Before you start

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.

Solution 1Recommended

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.

1
Open SQL View

In Access, select Create > Query Design, then switch to SQL View.

2
Enter the INSERT statement

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.

3
Run the query

Select Run on the query design ribbon and confirm the append prompt if Access displays one.

4
Check the new record

Open the Individual table from the Navigation Pane and look for the new record. Refresh or reopen the table if it was already open.

Specify Destination Fields and Run the INSERT Query
If IndividualID is AutoNumber: Omit IndividualID and its value from the statement so Access can generate the ID. Include values for any other required fields.
Free Microsoft Office alternative

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.

Work with tabular data in WPS Spreadsheets.Open and edit common Microsoft Office formats, including DOCX, XLSX, and PPTX.Use a familiar interface for everyday document tasks.Move compatible Office files into WPS Office with minimal disruption.
microsoft office alternative - wps office

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.