Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    99

    Unanswered: Query to output only records updated since x date

    Hi all,

    Probably a no brainer but could someone help me to create a query that only outputs records updated or modified since x date.

    This way I can only output records that have been changed.

    Many thanks,

    David
    pachamama
    www.researchbank.co.uk
    Fortune Global 500 Databank

  2. #2
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Do you have a field for date updated ?
    The follwing assumes you do and the field is called dateupdated.
    Code:
    Select *
    From tablename
    Where dateupdated > [Enter a date]
    Darasen

  3. #3
    Join Date
    Feb 2004
    Posts
    99
    Thanks Darasen, will have a crack at it.

    David
    pachamama
    www.researchbank.co.uk
    Fortune Global 500 Databank

Posting Permissions

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