Reports grouped by months.. (1 Viewer)

[endri81]

Hi
I have data in intervals by 3 months as in file attached where is shown 3month beginning date and ending date.I need to group by 6 month or one year period.
How is this possible?
Regards

 

[vbaInet]

What version of Access are you using?

 

[endri81]

Access 2003.
This is not by my choice but the office where the program will be used have only Access 2003 and no will to change

 

[vbaInet]

Access 2003 is perfectly fine

To group by year you use the Year() function to get the year portion of your date field and group on that.

To group by 6 month intervals you would do something like:

Month([DateField]) < 7

... then group on this field. This will return True (i.e. -1) if the month is between Jan and Jul, and False if it isn't (i.e. 0). So -1 will come before 0.