update query error

[koncreat]

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.

[aytee111]

Month is a reserved word, try changing the name of the field to something else and see if this solves the problem.

Post the full SQL.

[koncreat]

I changed it to month and stll get the error. I tried to switch to SQL view but i cant because i get the error

[koncreat]

Month([Date_Entered]) This appears to be the problem as it keeps pointing to this.

[aytee111]

I changed it to month

It was already set to "Month"!

Remove that field, then it will allow you to get the SQL.

[koncreat]

Sorry i meant changed it to Mon, same error. Removed it all together and now getting the error for the Dayay([Date_Entered]) field

[aytee111]

So the problem lies with Date_Entered. Is it from a table or are you trying to get prompted for it?

[koncreat]

At first i wanted to be prompted for a date range but have since removed it just to see if that was the problem.