Results 1 to 2 of 2

Thread: Sql Query

  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Question Unanswered: Sql Query

    Hi,
    I am working with Access Reports, one of my report has Effective Date, Last Modified Date and some other fields. my question is i want the Present Changes Date and Previous changes Date when i run the Report. how to write query for this one.. I appreciate your help.
    Thanks
    Vasmsy

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Sql Query

    Originally posted by vasmsy
    Hi,
    I am working with Access Reports, one of my report has Effective Date, Last Modified Date and some other fields. my question is i want the Present Changes Date and Previous changes Date when i run the Report. how to write query for this one.. I appreciate your help.
    Thanks
    Vasmsy
    You can
    1. copy the Effective date in the LastModifiedDate
    2. write the system date in the Effective date

    1. UPDATE yourTable SET yourTable.[LastModified Date] = [Effective Date];


    2. UPDATE yourTable SET yourTable.[EffectiveDate] = date();

Posting Permissions

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