I have information from two tables that i need to append into one table to create the report. So I created a make table query to create the table i will use to append the data to. That worked with no issue. So now i have two queries that i need to run after a user enters the start and end dates and the data update the table. When i originally did this the query was an append query and ran successfully but the second query would delete the data the first query appended to the table. I realized then that it would need to be an update query and not an append query. The problem that i have run into is after making the query an update query i am getting an error. I have three fields that break down the date to month, day and year. The field for month is Month:Month([Date_Entered]). The error:
Month:Month([Date_Entered]) is not a valid name. Make sure that it does not include invalid characters or punctuation and that is not too long.
Since this works if the query is an append query I'm not sure what is wrong.