Report totally

[Bunky]

I have several reports that mgmt needs to have totally on our fiscal year;
not the calendar year. Currently, the report is totally on a week, on a
month, and then on a year. Everything is working just great but the totally
on the year. Our fiscal year goes from 11-1 to 10-31. How do I tell the
reporting to use the time frame I need?

Thanks for you help.

 

[KARL DEWEY]

Use an additional field just for Fiscal Year --
Fiscal_Year: Format(DateAdd("m", 2, [YourDateField]), "yyyy")

 

[Bunky]

Karl,
Thanks for responding so quickly. Unfortunately, I must have not explained
the problem enough or I don't understand your response.

These reports are using the 'Sorting and Grouping' feature to create breaks
and totals where they should be happening. The report is fed a 'Week Ending
Date' and on the Group On function we select Week, Month, or Year.

Where would I put your solution?

Thanks

Use an additional field just for Fiscal Year --
Fiscal_Year: Format(DateAdd("m", 2, [YourDateField]), "yyyy")

--
KARL DEWEY
Build a little - Test a little

I have several reports that mgmt needs to have totally on our fiscal year;
not the calendar year. Currently, the report is totally on a week, on a
month, and then on a year. Everything is working just great but the totally
on the year. Our fiscal year goes from 11-1 to 10-31. How do I tell the
reporting to use the time frame I need?

Thanks for you help.

 

[KARL DEWEY]

You would put my post as a new field in the query design view grid. I take
the actual calendar date and converts it to a Fiscal Year for sorting and
groupting.
--
KARL DEWEY
Build a little - Test a little

Karl,
Thanks for responding so quickly. Unfortunately, I must have not explained
the problem enough or I don't understand your response.

These reports are using the 'Sorting and Grouping' feature to create breaks
and totals where they should be happening. The report is fed a 'Week Ending
Date' and on the Group On function we select Week, Month, or Year.

Where would I put your solution?

Thanks

Use an additional field just for Fiscal Year --
Fiscal_Year: Format(DateAdd("m", 2, [YourDateField]), "yyyy")

--
KARL DEWEY
Build a little - Test a little

I have several reports that mgmt needs to have totally on our fiscal year;
not the calendar year. Currently, the report is totally on a week, on a
month, and then on a year. Everything is working just great but the totally
on the year. Our fiscal year goes from 11-1 to 10-31. How do I tell the
reporting to use the time frame I need?

Thanks for you help.

 

[Bunky]

YOU ARE ABSOLUTELY AWESOME!!!!!

Works like a champ! Thanks so much!

You would put my post as a new field in the query design view grid. I take
the actual calendar date and converts it to a Fiscal Year for sorting and
groupting.
--
KARL DEWEY
Build a little - Test a little

Karl,
Thanks for responding so quickly. Unfortunately, I must have not explained
the problem enough or I don't understand your response.

These reports are using the 'Sorting and Grouping' feature to create breaks
and totals where they should be happening. The report is fed a 'Week Ending
Date' and on the Group On function we select Week, Month, or Year.

Where would I put your solution?

Thanks

Use an additional field just for Fiscal Year --
Fiscal_Year: Format(DateAdd("m", 2, [YourDateField]), "yyyy")

--
KARL DEWEY
Build a little - Test a little


:

I have several reports that mgmt needs to have totally on our fiscal year;
not the calendar year. Currently, the report is totally on a week, on a
month, and then on a year. Everything is working just great but the totally
on the year. Our fiscal year goes from 11-1 to 10-31. How do I tell the
reporting to use the time frame I need?

Thanks for you help.