Re: Updating a field with calculated dates from other field

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 10:36:00 -0500

Please do not post your questions in multiple groups. You end up with more
than one person working on your issue and wasting peoples' time. This
question has been asked and answered in another group.

"Chris1" <anonymous@discussions.microsoft.com> wrote in message
news:1152501c441a3$59d89f60$a301280a@phx.gbl...
Hi

I really need some help on this one:

I have one table containing tools to be maintained:
There is a [Period} field which can contain the following
values: 1 Year, 6 months, and 3 months.
Each tool will be matched with one of these periods.

The second field contains date when last check was done
[LastChecked].

The third field [NextDue]is the one that needs to
calculate from the 2 above; For example if I have a tool
checked on the 24 May 04, and its period is 6 months, I
would like to see the result of 24 May 04 + 6 months
automatically in the third field.

Do I need a condition in the validation rule in the
table?, or should I have an expression in queries? In
either case what would that be?

Many Thanks,
Chris.

Relevant Pages

  • Re: sort by 2nd and 3rd fields
    ... Harry> But the folllowing will screw up the 2nd (major sort) column. ... The -n option applies to all the fields, so the second field gets ... sorted numerically as well as the third field. ...
    (comp.unix.shell)
  • Re: data all in column 1
    ... always the second field, third line is third field, etc? ... Sub testme01() ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Determine Column Width and Bound Column
    ... How Do I determine Column width in a combobox. ... The first field SHipId not to be shown ... Second Field is the Company Name ... Third Field is the Address ...
    (microsoft.public.access.forms)
  • Re: Ascending Sort Problem
    ... "PC Datasheet" wrote: ... > In the second field, ... > In the third field, ... But when I sort I get the following, ...
    (microsoft.public.access.queries)
  • How to update a field with value from 2 calculated fields (dates)?
    ... The second field contains date when last check was done ... The third field is the one that needs to ... Do I need a condition in the validation rule in the ... or should I have an expression in queries? ...
    (microsoft.public.access.queries)