H
HollyH
I have a report that prints the data in two subreports
based on a company specific time period. The time period
is broken out as follows: XXXX-X The first two numbers
are a year the second two numbers indicate a period and the
last number is the week within the period.
I am filtering using the statement:
[WEEK] Like [Enter Period] & "*"
In the report I am only getting the first week entered.
Ie. if the first entry for 6911 was made in week 1 (6911-1)
then weeks 2, 3, & 4 are not showing up even if there are
entries. If the first entry was week 3 (6911-3) week 4
doesn't show up even if it has entries.
If I move the report to the details section, I get all of
the weeks, but they are broken out. I need them all together.
I can't figure out why I am not getting all of the weeks.
Help
based on a company specific time period. The time period
is broken out as follows: XXXX-X The first two numbers
are a year the second two numbers indicate a period and the
last number is the week within the period.
I am filtering using the statement:
[WEEK] Like [Enter Period] & "*"
In the report I am only getting the first week entered.
Ie. if the first entry for 6911 was made in week 1 (6911-1)
then weeks 2, 3, & 4 are not showing up even if there are
entries. If the first entry was week 3 (6911-3) week 4
doesn't show up even if it has entries.
If I move the report to the details section, I get all of
the weeks, but they are broken out. I need them all together.
I can't figure out why I am not getting all of the weeks.
Help