Results 1 to 3 of 3

Thread: Count down days

  1. Nov 8th, 2005, 09:33 AM #1
    alexanderjames
    alexanderjames is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2005
    Location
    South Africa
    Posts
    400

    Count down days

    Hi

    I have an access database with a field called "Days remaining" now what i need to do is, say if an amount of days gets added to the field for instance
    365 then everyday that amount must decrease by one. is this possible, please can someone help me.

    Many thanks
    Reply With Quote Reply With Quote
  2. Nov 8th, 2005, 09:48 AM #2
    FishGuy
    FishGuy is offline
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: Count down days

    If you mean by just using sql Server you could just have a scheduled task that runs once every day and runs an sp that updates all values for that field which are greater than 0 by minus one.
    Last edited by FishGuy; Nov 8th, 2005 at 11:32 AM.
    Reply With Quote Reply With Quote
  3. Nov 8th, 2005, 09:53 AM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Count down days

    Alternatively you could have a View, which contains the other fields from the table, and this field calculated using SQL.

    This method will slow down access to the data tho.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width