Datepart year - + 6 months

[Wayne-I-M]

Hi

I hav a crostab query showing booking per year for ski trips but this is
making problems.

Ski trips need to be shown during the major season dates.
So any thing that has a departure date between August1st and the following
July
31st is that year -

1/11/09 = 2010 as it is after August 1st
2/2/09 = 2009 as it is previous to July 31st

Basically a ski season runs during the winter and anything during that
winter needs to be shown during the major season Jan Feb Mar of that year so
Nov and Dec are classed as the next year

Hope all this makes sense

so can't just use
TripYear: DatePart("yyyy",[tblEvents]![EVTStart])
as there may be a trip during November which would need to be shown as the
following year

any ideas

 

[Douglas J. Steele]

TripYear: IIf(Month([tblEvents]![EVTStart]) < 8,
DatePart("yyyy",[tblEvents]![EVTStart]),
DatePart("yyyy",[tblEvents]![EVTStart]) + 1)

 

[Wayne-I-M]

Thank you Douglas - excelent

When Mr Obama is finished I will vote for you and John Spencer


--
Wayne
Trentino, Italia.

TripYear: IIf(Month([tblEvents]![EVTStart]) < 8,
DatePart("yyyy",[tblEvents]![EVTStart]),
DatePart("yyyy",[tblEvents]![EVTStart]) + 1)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi

I hav a crostab query showing booking per year for ski trips but this is
making problems.

Ski trips need to be shown during the major season dates.
So any thing that has a departure date between August1st and the following
July
31st is that year -

1/11/09 = 2010 as it is after August 1st
2/2/09 = 2009 as it is previous to July 31st

Basically a ski season runs during the winter and anything during that
winter needs to be shown during the major season Jan Feb Mar of that year
so
Nov and Dec are classed as the next year

Hope all this makes sense

so can't just use
TripYear: DatePart("yyyy",[tblEvents]![EVTStart])
as there may be a trip during November which would need to be shown as the
following year

any ideas

 

[Douglas J. Steele]

Being Canadian prevents me from being eligible. <g>

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thank you Douglas - excelent

When Mr Obama is finished I will vote for you and John Spencer


--
Wayne
Trentino, Italia.

TripYear: IIf(Month([tblEvents]![EVTStart]) < 8,
DatePart("yyyy",[tblEvents]![EVTStart]),
DatePart("yyyy",[tblEvents]![EVTStart]) + 1)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi

I hav a crostab query showing booking per year for ski trips but this
is
making problems.

Ski trips need to be shown during the major season dates.
So any thing that has a departure date between August1st and the
following
July
31st is that year -

1/11/09 = 2010 as it is after August 1st
2/2/09 = 2009 as it is previous to July 31st

Basically a ski season runs during the winter and anything during that
winter needs to be shown during the major season Jan Feb Mar of that
year
so
Nov and Dec are classed as the next year

Hope all this makes sense

so can't just use
TripYear: DatePart("yyyy",[tblEvents]![EVTStart])
as there may be a trip during November which would need to be shown as
the
following year

any ideas