Fix Access VBA Append Query with Multiple Values
Question details
The user needs the correct Microsoft Access VBA append query syntax to insert one record with multiple values into a destination table.

- 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.
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.
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.
Open the Access query in Design View or inspect the INSERT INTO field list and note the exact column order.
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 & "').
Execute the VBA procedure and confirm that the number of values inside the single parentheses equals the number of destination fields.

Use Multiple Parenthesized Value Groups Only for Multiple Rows
Use this when you intentionally need to append multiple records in one SQL statement.
Use a Parameterized Append Query to Avoid String Concatenation Errors
Use this when form values contain quotes or when you want safer, more maintainable VBA.
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.

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.




