Run a query on my DB, to list all issues for a particular fiscal y Meg 12/3/2008 7:20:26 PM 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

Re: Run a query on my DB, to list all issues for a particular fiscal y "Brendan Reynolds" <brenreyn[ at ]discussions.microsoft.com> 12/4/2008 9:52:17 AM "Meg" <Meg[ at ]discussions.microsoft.com> wrote in message news:44A4C2AB-D7D2-467D-9C40-A6E21C7E7CA2[ at ]microsoft.com... <snip> [Quoted Text] > 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? -- Brendan Reynolds

Re: Run a query on my DB, to list all issues for a particular fisc Meg 12/8/2008 7:15:01 PM 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" wrote: [Quoted Text] > "Meg" <Meg[ at ]discussions.microsoft.com> wrote in message > news:44A4C2AB-D7D2-467D-9C40-A6E21C7E7CA2[ at ]microsoft.com... > <snip> > > 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? > > -- > Brendan Reynolds >

Re: Run a query on my DB, to list all issues for a particular fisc Meg 12/22/2008 3:05:04 PM Thanks, this worked. MEG "Brendan Reynolds" wrote: [Quoted Text] > "Meg" <Meg[ at ]discussions.microsoft.com> wrote in message > news:44A4C2AB-D7D2-467D-9C40-A6E21C7E7CA2[ at ]microsoft.com... > <snip> > > 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? > > -- > Brendan Reynolds >