Re: Update Query with User-defined function?

You could try:

(a) to write the update query from scratch in SQL

or

(B)

- Write a simpler select query, with the same fields but without the
function (e.g., instead of the function just add or concatenate the two
fields)

- Change that simpler query to an update

- Add the function to the resulting Update query

Also, it's a good idea to specify that your function returns a long (or
other data type).

"Greg Strong" <NoJunk@NoJunk4U².com> wrote in message
news:eurqj1p8sj3m5iuc5j3asq6rqejr4a8kf0@xxxxxxxxxx
> On Fri, 30 Sep 2005 09:55:35 -0700, "Bruce Rusk"
> <brusk_spambegone_@xxxxxxxxxxxxx> wrote:
>
>>Normally you'd use periods, not exclamation points, in SQL. Try switching
>>and see if that helps.
>
> No. I tried replacing "!" with "." and also removing the brackets in
> Access's GUI query builder. After I leave the field Access puts the
> brackets back, and I get the same error message except the exclamation
> points are replaced with the periods. Thanks for the suggestion.
>
> --
> Regards,
>
> Greg Strong


.