Run a query on my DB, to list all issues for a particular fiscal y

[Meg]

I have a table that has a tracking number, date originated, issue, and a crop
year. I have a query that generates a report by crop year, which the user
puts in the crop year (for example: 2007) and it generates the report.

However, now they want another report based on fiscal year. There is no
where that I capture the fiscal year, but I do have the dt_originated field
that on my query I put the criteria -- Between [BeginDate] And [EndDate]
which then prompts the user to enter the Begin Date (such as: 10/1/2007)
and the End Date (such as: 9/30/2008) and I get the report fine, however I
want my Heading to print 2008 Fiscal Year Report. The 2008 would be based on
what 2 dates they put in.

Can anyone tell me how this can be done, if it is at all possible??? I am
desparate. I tried making a table and put in about 30 years of dates for the
Fiscal Year with the BeginDate and EndDate and thought I could let the People
just select the Fiscal Year, but I couldn't figure that out either. I am
using Access 2007.

Any help would be appreciated.

MEG

 

[Brendan Reynolds]

However, now they want another report based on fiscal year. There is no
where that I capture the fiscal year, but I do have the dt_originated
field
that on my query I put the criteria -- Between [BeginDate] And
[EndDate]
which then prompts the user to enter the Begin Date (such as: 10/1/2007)
and the End Date (such as: 9/30/2008) and I get the report fine, however
I
want my Heading to print 2008 Fiscal Year Report. The 2008 would be based
on
what 2 dates they put in.

<snip>

Is the fiscal year always the same year as the year of the end date? If so,
it's just Year([Name of your End Date Parameter Here])

The Year() function takes one argument, a date, and returns the year part of
that date.

If not, how exactly is the fiscal year determined given the beginning and
ending dates?

 

[Meg]

Can you tell me where I put the Year [EndDate] I guess EndDate is what I put
in the brackets or would it be dt_originated. I don't have a field called
EndDate that is what the user inputs.

Am I making any sense?

Thanks,

MEG

However, now they want another report based on fiscal year. There is no
where that I capture the fiscal year, but I do have the dt_originated
field
that on my query I put the criteria -- Between [BeginDate] And
[EndDate]
which then prompts the user to enter the Begin Date (such as: 10/1/2007)
and the End Date (such as: 9/30/2008) and I get the report fine, however
I
want my Heading to print 2008 Fiscal Year Report. The 2008 would be based
on
what 2 dates they put in.

<snip>

Is the fiscal year always the same year as the year of the end date? If so,
it's just Year([Name of your End Date Parameter Here])

The Year() function takes one argument, a date, and returns the year part of
that date.

If not, how exactly is the fiscal year determined given the beginning and
ending dates?

 

[Meg]

Thanks, this worked.

MEG

However, now they want another report based on fiscal year. There is no
where that I capture the fiscal year, but I do have the dt_originated
field
that on my query I put the criteria -- Between [BeginDate] And
[EndDate]
which then prompts the user to enter the Begin Date (such as: 10/1/2007)
and the End Date (such as: 9/30/2008) and I get the report fine, however
I
want my Heading to print 2008 Fiscal Year Report. The 2008 would be based
on
what 2 dates they put in.

<snip>

Is the fiscal year always the same year as the year of the end date? If so,
it's just Year([Name of your End Date Parameter Here])

The Year() function takes one argument, a date, and returns the year part of
that date.

If not, how exactly is the fiscal year determined given the beginning and
ending dates?