Creating 6 monthly periods

[Dinsdale]

Team,

I am wanting to create a report which graphs periods based on a 6
monthly period, and also generates a separate graph for all the previous
6 monthly periods eg, 1st 2004, 2nd 2003, 1st 2003, etc. The other thing
that will cause an issue is that the code needs to be able to find the
first date of entry into the database (the same front end for 4
different back ends, all starting at a different date), and build the
number of graphs automatically from that date.

There is a lot of code out there, but the 6 monthly bit is causing me
some challenge, as well as the building up of the different periods.

Any assistance is gratefully accepted.

Andrew

 

[Guest]

Create a new query or modify the query with a column PERIOD:IIF(Month([Datefield])>6,2,1
You can extend this to check for nulls if required. This will give you a column for the period. You can build more complex versions of this to include Year & period togethe
HT
Terr

----- Dinsdale wrote: ----

Team

I am wanting to create a report which graphs periods based on a 6
monthly period, and also generates a separate graph for all the previous
6 monthly periods eg, 1st 2004, 2nd 2003, 1st 2003, etc. The other thing
that will cause an issue is that the code needs to be able to find the
first date of entry into the database (the same front end for 4
different back ends, all starting at a different date), and build the
number of graphs automatically from that date

There is a lot of code out there, but the 6 monthly bit is causing me
some challenge, as well as the building up of the different periods

Any assistance is gratefully accepted

Andre