Quarters in a report (2000)

**Leesha** · 2004-05-23 01:03

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

**HansV** · 2004-05-23 01:07

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.

**Leesha** · 2004-05-23 01:17

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

Thanks so much,
Leesha

**HansV** · 2004-05-23 01:21

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.

**Leesha** · 2004-05-23 01:23

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

Thanks again,
Leesha

Thread: Quarters in a report (2000)

Thread Tools