Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    163

    Unanswered: Generate Query results based on Date

    Dear Seniors,

    Is it possible to generate the query results based on Cut off date?

    i.e. I have a database where the datas are updated on daily basis. Now my boss wants to have the report based on some cut off date. For a simple query I am able to generate the report and its fine.

    Whereus I am facing problem when I generate a results with multiple query/Table.

    For ex my Table contains the following data

    DOC1 - IFR - 02-Feb-14
    DOC2 - IFR - 05-Mar-14
    DOC3 - IFR - 06-Mar-14
    DOC1 - IFA - 03-Mar-14
    DOC2 - IFA - 03-Apr-14
    DOC3 - IFA - 05-Apr-14

    And I created a query for getting the latest status of document based on maxdate

    So my query results in
    DOC1 - IFA - 03-Mar-14
    DOC2 - IFA - 03-Apr-14
    DOC3 - IFA - 05-Apr-14

    Now I want the same query to return the results as follows based on some date say 30-Mar-14

    DOC1 - IFA - 03-Mar-14
    DOC2 - IFR - 05-Mar-14
    DOC3 - IFR - 06-Mar-14

    But I am getting the result as follows
    DOC1 - IFA - 03-Mar-14

    Could you please help me how to sort out this issue ?

    I hope that I had explained my problem in clear, please let me know for further clarifications.
    Thanks and Regards
    R. Vadivelan

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Select * from tbl where [MyDateFld]=#" & forms!frmMain!txtDate & "#"

Posting Permissions

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