Update Error

[Guest]

I am receiving an error message that reads: Operation Must Be an Updateable
Query.

I am trying to update the field MAX CHARE DAYS TOTAL. This field comes from
a previous query where this field itself was calculated by the query. I have
to update this field (in which all records will read the value 30 or 31), to
this:

IIf(DateDiff("d",[Start Date],[Arrival Date])>CLng(Rates![Free
Days]),DRDQ_02![Max Charge Days Total] Or IIf(DateDiff("d",[Start
Date],[Arrival Date])<CLng(Rates![Free Days]),(("Max Charge Days
Total")-CLng((Rates![Free Days])-(DateDiff("d",[Start Date],[Arrival
Date]))))))


I am trying to either place the original MAX CHARGE DATE in the MAX CHARGE
DATE FIELD, or I am trying to update it to the MAX CHARGE DATE minus free
days in another table, minus the difference between [Start Date],[Arrival
Date].


Can anyone help me?

 

[John W. Vinson]

I am receiving an error message that reads: Operation Must Be an Updateable
Query.

I am trying to update the field MAX CHARE DAYS TOTAL. This field comes from
a previous query where this field itself was calculated by the query. I have
to update this field (in which all records will read the value 30 or 31), to
this:

IIf(DateDiff("d",[Start Date],[Arrival Date])>CLng(Rates![Free
Days]),DRDQ_02![Max Charge Days Total] Or IIf(DateDiff("d",[Start
Date],[Arrival Date])<CLng(Rates![Free Days]),(("Max Charge Days
Total")-CLng((Rates![Free Days])-(DateDiff("d",[Start Date],[Arrival
Date]))))))


I am trying to either place the original MAX CHARGE DATE in the MAX CHARGE
DATE FIELD, or I am trying to update it to the MAX CHARGE DATE minus free
days in another table, minus the difference between [Start Date],[Arrival
Date].

Please post the complete SQL of the query. I suspect your expression is not
the source of the problem but rather something about the query.

John W. Vinson [MVP]