Re: Updating a field with calculated dates from other field

From: Chris1 (anonymous_at_discussions.microsoft.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 01:39:30 -0700

Please do not waist my time with responses of the level of
yours. I find your answer rude and certainly unhelpful. As
for your response from the Queries side, I got much better
from someone else. I have used this forum for years and
never encountered such rudness. If you are not happy to
help just ignore the messages!

Chris1
>-----Original Message-----
>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

  • ENOBUFS and DNS...
    ... ENOBUFS being returned to UDP-using applications. ... lots of DNS queries to verify my address. ... solution be for me simply not to send any more mail to the lists? ... takes more time to push out responses than it does for them to come in. ...
    (freebsd-net)
  • Re: Additional DC problem
    ... were to have multiposted to multiple groups all at once instead of many ... individual posts so the responses would have come back to all of them ... Microsoft Windows MVP - Active Directory ...
    (microsoft.public.win2000.active_directory)
  • Re: Form and subform with a many to many relationship
    ... independently to multiple groups, responses don't show up across all groups ... Check the newsgroup netiquette on crossposting/multiposting... ... > skill has many related training courses, and vice versa, 1 given training ...
    (microsoft.public.access.forms)
  • Re: Additional DC problem
    ... >were to have multiposted to multiple groups all at once ... >individual posts so the responses would have come back to ... >Microsoft Windows MVP - Active Directory ...
    (microsoft.public.win2000.active_directory)
  • Re: Make-table (?Materialized views?) of complicated cross tabs, calculated field
    ... be able to run fairly sophisticated queries in Access. ... The problem is I'm compiling about 10 fields of "1-5" rank responses ... I do the crosstab on that Union. ...
    (comp.databases.ms-access)