Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    12

    Unanswered: Form Problem Access 2002

    I have a form which will be used to view people that are close to a deadline. The form includes people that are 3 weeks away from the deadline to the deadline date "WHERE Deadline<Now()+21 AND Deadline>=Now()" So now I have people that are 3 weeks from deadline which my users are to start dealing with. To make sure that the ones closes to the deadline stand out, I want the record's detail to either go red or have the font go red. Is there any way to do that? For me, When one changes, they all change. Thanks in advance

    Jon

  2. #2
    Join Date
    May 2004
    Posts
    63
    Have you thought about using conditional formatting ?

  3. #3
    Join Date
    Jul 2004
    Posts
    125
    "WHERE Deadline<Now()+21 AND Deadline>=Now()"
    This should be "WHERE [Deadline] Between Now() And Dateadd("d", 21,Now())"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •