Date criteria in a crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the wizard, I am able to create a crosstab query that sorts each
volunteer (as row heading) , the number of volunteer hours (the value) and
the dates of service (the column heading, grouped by year). I need to group
the dates of service not by calendar year but by defining a year as beginning
10/1 and ending 9/30.

Thanks in advance for any help offered.
 
On Mon, 29 Nov 2004 09:07:04 -0800, "John Hargrove" <John
Using the wizard, I am able to create a crosstab query that sorts each
volunteer (as row heading) , the number of volunteer hours (the value) and
the dates of service (the column heading, grouped by year). I need to group
the dates of service not by calendar year but by defining a year as beginning
10/1 and ending 9/30.

Thanks in advance for any help offered.
Click to expand...

Use a criterion of
= DateSerial([Enter FY:] - 1, 10, 1) AND < DateSerial([Enter FY:], 11, 1)
Click to expand...

You'll also need to put

[Enter FY:]

in the query's Parameters, defined as Number type.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top