Re: Update Query with User-defined function?

Hi Greg,

You certainly can use functions in the Update To of a query.

The standard syntax for referring to a field in a tables is using a
period instead of !:
tblOrderPrYr_Setup.EstRev
I don't know if this is the source of your problem.

Actually, in this case, since you only have one table in your From
clause, you don't need to refer to the table:
RtnRndEstRevPY(EstRev,ID).

If these changes don't help, I suggest you pare your query down to the
simplest components that demonstrate your problem, and then post the
SQL of the update query.

Jerry

.