How to Add Text and the Current Date in an Access Append Query
Question details
The user needs to append existing data in Microsoft Access while simultaneously inserting the current date and specific text strings into designated fields.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Appending records to a destination table and including dynamic timestamps or static text strings during the process.
- Observed behavior
- A requirement to format an INSERT INTO SQL statement that successfully writes the Now() function and text constants into target table fields.
Before running an append query, ensure you have verified your destination table structure and reviewed your query in Datasheet View, as appended records cannot be easily undone without manual deletion.
Use an INSERT INTO ... SELECT Statement
The most efficient way to append data from a source table while adding current dates and fixed text is using the SELECT clause combined with the Now() function.
This method is ideal when you need to copy existing records from one table to another while simultaneously injecting a timestamp and custom status or error text.
Open your database in Microsoft Access, navigate to the 'Create' tab on the ribbon, and click on 'Query Design'.
Close the 'Show Table' dialog box that appears, then click the 'SQL' button located in the top left corner to switch to SQL View.
Specify your destination table and the fields you want to populate. For example: INSERT INTO DestinationTable (CurrentDate, ErrorText)
Use the Now() function for the date and single quotes for your text values. Example: SELECT Now() AS CurrentDate, 'Error text' AS ErrorText FROM SourceTable;
Click the 'Run' button (the red exclamation mark) in the Query Design ribbon to execute the append operation.

Use an INSERT INTO ... VALUES Statement for Single Records
If you are not pulling data from a source table and only need to append one row consisting of fixed text and the current date, use the VALUES syntax.
Manage Your Data with WPS Spreadsheet as a Free Alternative
While Microsoft Access is a dedicated database tool, many data management, appending, and tracking tasks can be accomplished easily in spreadsheets. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office, making data handling seamless.
- 1. Download and Install WPS Office: Get the free installation package from the official WPS website and complete the quick setup.
- 2. Open WPS Spreadsheet: Launch the Spreadsheet application and open or create a new data table.
- 3. Insert Date Functions: Type =NOW() in any cell to instantly capture the current date and time for your data tracking.

Frequently Asked Questions
Can I use Date() instead of Now() in an Access append query?
Yes. While Now() inserts both the current system date and time, using the Date() function will insert only the current date without the time component.
Why am I getting a syntax error when inserting text into my query?
Syntax errors typically occur if text strings are not properly wrapped. Ensure your static text is enclosed in single quotes (e.g., 'Error text') inside your SQL statement.
How do I append fields from the source table alongside the date and text?
You can combine them by including the source field names in both your destination field list and your SELECT list. For example: INSERT INTO DestTable (SourceField1, CurrentDate) SELECT Field1, Now() FROM SourceTable;.




