H
HollyH
I have a report where I make
[week] like [enter period number] & "*"
weeks are the period plus 1, 2, 3, or 4
When I link the field [week] in the subreport, I only get
the entries for the first week that shows up. ie. If there
is an entry for week 1 only the week 1 entries show even if
there are week 3 entries.
I need all of the entries for the period (all four weeks)
to show.
When I take the subform data and place it directly into the
report it works fine.
The reason for the subreport is to keep from having to
change every report every time the rates change. I could
do a series of queries but would rather not and the section
I am talking about has a bunch of equations going on.
Does anyone have an idea?
[week] like [enter period number] & "*"
weeks are the period plus 1, 2, 3, or 4
When I link the field [week] in the subreport, I only get
the entries for the first week that shows up. ie. If there
is an entry for week 1 only the week 1 entries show even if
there are week 3 entries.
I need all of the entries for the period (all four weeks)
to show.
When I take the subform data and place it directly into the
report it works fine.
The reason for the subreport is to keep from having to
change every report every time the rates change. I could
do a series of queries but would rather not and the section
I am talking about has a bunch of equations going on.
Does anyone have an idea?