VBA & Macro Problems

Fix Access VBA Append Query with Multiple Values

Jason MillerJason Miller Nov 13, 2026 869 views

Question details

The user needs the correct Microsoft Access VBA append query syntax to insert one record with multiple values into a destination table.

Fix Access VBA Append Query with Multiple Values
Product
Microsoft Access VBA
Device & OS
not provided
Scenario
Building a VBA INSERT INTO append query using form controls such as txtRewardsNum and Guest.
Observed behavior
Separate parenthesized value groups cause Access to raise a field/value count mismatch instead of inserting one record.
Before you start

Open the Access query in Design View to count the destination fields and note their order, then verify whether your SQL is intended to insert one record or multiple records.

Solution 1Recommended

Use One Parenthesized VALUES Clause for a Single Append Query

Use this when you are inserting one record and want to match the destination field list exactly.

In a Microsoft Access VBA INSERT INTO statement, the VALUES keyword must be followed by one pair of parentheses containing every value for that record. If you wrap each value or groups of values in separate parentheses, Access interprets them as separate rows or raises a field/value mismatch error.

1
Count the destination fields

Open the Access query in Design View or inspect the INSERT INTO field list and note the exact column order.

2
Build one VALUES clause

In the VBA editor, write the VALUES keyword followed by a single opening parenthesis, list all values in the same order as the fields, and close with one parenthesis. For example: INSERT INTO Rewards (RewardsNum, Guest) VALUES ('" & Me.txtRewardsNum & "', '" & Me.Guest & "').

3
Run the append query

Execute the VBA procedure and confirm that the number of values inside the single parentheses equals the number of destination fields.

Use One Parenthesized VALUES Clause for a Single Append Query
Query runs without mismatch error: A single parenthesized VALUES clause inserts one record and matches the field list.
Free Microsoft Office alternative

Use WPS Office as a Free Alternative for Daily Spreadsheet and Document Tasks

Microsoft Access is not available in WPS Office, but WPS Spreadsheets, Writer, and Presentation provide a free, lightweight way to open and edit Excel, Word, and PowerPoint files with familiar formatting and VBA macro support.

Supports VBA macros in Excel workbooks for query-like automation without AccessSeamlessly opens and saves .xlsx, .xlsm, .docx, and .pptx filesFree and lightweight office suite with a familiar ribbon interfaceEasy migration from Microsoft Office with high compatibility
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access VBA append query say the number of query values and destination fields must match?

Because each VALUES clause must contain the same number of values as the destination field list. For a single record, place all values inside one pair of parentheses.

Can I use multiple parentheses in one Access VBA INSERT INTO statement?

Yes, but only when appending multiple rows. Each parenthesized value group must match the field list exactly and be separated by commas.

How do I concatenate text values from form controls safely in VBA?

Build the string with proper delimiters, such as single quotes around text values, or use a parameterized append query to avoid quote and concatenation errors.

Does WPS Office support Microsoft Access VBA?

WPS Office does not include Microsoft Access, but WPS Spreadsheets supports Excel workbooks and VBA macros for spreadsheet automation.