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

  • Thread starter Thread starter Meg
  • Start date Start date
M

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
 
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.
Click to expand...

<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?
 
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

Brendan Reynolds said:
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.
Click to expand...

<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?
Click to expand...
 
Thanks, this worked.

MEG

Brendan Reynolds said:
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.
Click to expand...

<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?
Click to expand...
 
Back
Top