Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Making A Simple Report

Discussion in 'Information Technology' started by emanuel.levy@gmail.com, Nov 4, 2005.

  1. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    If I have a field called that is used to see when a program began and I
    want to create a report that shows when it is 90 days from the year
    anniversary and then 60 days from the year anniversary how do I do
    that?

    I would want it to use the current date as the starting point.

    Example if a report was generated on 11/5/05 I would want to see all
    entries that were made 8/5/04 on the 90 day report and 9/5/04 on the 60
    day report.

    I would have this report run through a switchboard icon.
     
  2. Loading...

    Similar Threads Forum Date
    Partition 1947 - The Making Of Refugees History of Sikhism Mar 18, 2015
    Making The Change With Hope & Faith - Sikh Advocate Prabhjot Singh, Md Sikh Youth Mar 11, 2015
    Heritage Sikhs making Their History in Malaysia History of Sikhism May 18, 2013
    Inspirational Making a Difference: A School for Girls in Kenya Videos Mar 25, 2013
    Canada Star-struck’ security and limo drivers? Businesses complain TOIFA staff are making racist demands Breaking News Mar 18, 2013

  3. Pat Hartman (MVP)

    Pat Hartman (MVP)
    Expand Collapse
    Guest

    Use a query as the RecordSource for the report. Add criteria that prompts
    for the Number of days.

    Select ...
    From ...
    Where Date() - [How many days?] >= DateValue(YourDate);

    "emanuel.levy@gmail.com" wrote:

    > If I have a field called that is used to see when a program began and I
    > want to create a report that shows when it is 90 days from the year
    > anniversary and then 60 days from the year anniversary how do I do
    > that?
    >
    > I would want it to use the current date as the starting point.
    >
    > Example if a report was generated on 11/5/05 I would want to see all
    > entries that were made 8/5/04 on the 90 day report and 9/5/04 on the 60
    > day report.
    >
    > I would have this report run through a switchboard icon.
    >
    >
     

Share This Page