Using Access, what is wrong with this query, UPDATE family SET F17 = CDate(bday);

Question

Using Access, what is wrong with this query, UPDATE family SET F17 = CDate(bday);

Thomas Pape 0

UPDATE family SET F17 = CDate(bday) Where id = 1;

3 answers

Your answer

Answer 1

DBG 11,381 Volunteer Moderator

What error message were you getting?

Answer 2

Luis Angel Ñañez Llanos 431

Hi Thomas, I see no fault in the SQL query you share, as long as:

family, is the correct name of the table where the change will be made.
F17, is the correct name of the field to update.
bday, is the correct name of the column containing the value to convert with Cdate.
Id, is the correct name of the column and its data type is numeric.

Notify us of any news

Luis Angel Ñañez Llanos 431 Reputation points

2025-06-09T07:41:51.66+00:00

Hi,

I just wanted to know if the information provided was helpful.

If you have any other questions or concerns, please let me know.

If you find my answer helpful, please remember to mark it as a reply. This way, other user friends will know that the answer to your question in the title was answered here and they can quickly find the answer to their same question.

Thank you very much.

Answer 3

It appears to me that F17 is a cell reference in an Excel worksheet. If you imported a worksheet into a table and Access, and didn't rename that reference to a valid name, perhaps this could work. However, if this is a linked table in an Excel worksheet, it is not updateable.

Another potential problem is the value of bday. Where does that come from? How is it defined for this Update? I assume that this is the SQL from a query and not a string in VBA?

Thanks for providing sufficient information to allow us to offer useful suggestions.

Share via

Using Access, what is wrong with this query, UPDATE family SET F17 = CDate(bday);

3 answers

Your answer