Hi, I have a TargetDate field and a ResponseDate field. If Response
date is after TargetDate I want to autoenter NO in a new field called
ResponseInTime. Can anyone help. Thanks

Paul <(E-Mail Removed)> wrote in news:6275a968-5f0d-48a9-9d3b-
(E-Mail Removed):

> Hi, I have a TargetDate field and a ResponseDate field. If Response
> date is after TargetDate I want to autoenter NO in a new field called
> ResponseInTime. Can anyone help. Thanks
>

Because calculable data should never be stored in a table, the people
who developed Access did not waste time creating utilities to make this
easier.

The right way to get this calculated field is in a query,or a form.

=iif(ResponseDate > TargetDate, "NO","Yes") can be put in the Record
Source property of a form or report textbox.

ResponseInTime: if(ResponseDate > TargetDate, "NO","Yes") would be how
to enter it in a query.

If you insist in storing it in a field, put
[ResponseInTime] = iif(ResponseDate > TargetDate, "NO","Yes")
in the After_Update Event's visual basic code for the two 'time'
fields.

--
Bob Q.
PA is y I've altered my address.

On Jun 21, 11:23*am, Bob Quintal <rquin...@sPAmpatico.ca> wrote:
> Paul <burnsp...@hotmail.co.uk> wrote in news:6275a968-5f0d-48a9-9d3b-
> 0654d0898...@s9g2000yqm.googlegroups.com:
>
> > Hi, I have a TargetDate field and a ResponseDate field. If Response
> > date is after TargetDate I want to autoenter NO in a new field called
> > ResponseInTime. Can anyone help. Thanks
>
> Because calculable data should never be stored in a table, the people
> who developed Access did not waste time creating utilities to make this
> easier.
>
> The right way to get this calculated field is in a query,or a form.
>
> =iif(ResponseDate > TargetDate, "NO","Yes") can be put in the Record
> Source property of a form or report textbox.
>
> ResponseInTime: if(ResponseDate > TargetDate, "NO","Yes") would be how
> to enter it in a query.
>
> If you insist in storing it in a field, put
> [ResponseInTime] = iif(ResponseDate > TargetDate, "NO","Yes")
> in the *After_Update Event's visual basic code for the two 'time'
> fields.
>
> --
> Bob Q.
> PA is y I've altered my address.

Thanks for the info, The field that I am entering is Unbound, works
great. thanks