Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Quarters in a report (2000)

    Hi,

    I have a form that is being used to open various reports based on dates. It has a [FromDate] and [ToDate] command on it. I have another unbound command that has the formula =month([FromDate]). All works fine. What I need is to identify the "quarter" in which the the "month" lies. I'm thinking I need to write an If than statement to identify the quarter but I'm not sure how to do it, or, if there is an easier method.

    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quarters in a report (2000)

    If you put a text box on the report with control source FromDate, you can set the Format property to m to display the month number, or to q to display the quarter number.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quarters in a report (2000)

    WOW! That worked beautifully! I had no idea that could be done.

    Thanks so much,
    Leesha

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quarters in a report (2000)

    If you click in the Format property (in the Properties window) and press F1, you'll get more info about this property. The help subject should contain a link that explains the possibilities for the Date/Time data type. There is a series of built-in formats, and a series of codes you can use to create custom formats.

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quarters in a report (2000)

    Will do! I just always thought I was limited to the selections that were there!

    Thanks again,
    Leesha

Posting Permissions

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