A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pass a filter from report to subreport



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2004, 02:30 PM
Fons Ponsioen
external usenet poster
 
Posts: n/a
Default Pass a filter from report to subreport

Hi Holly. I do not quite follow what you have here. If
your report is grouped by reference number and week, that
it is critical to know where your subreport is placed (in
which band) and what the link is (reference number or
week). If you wish could you send me a copy of your mdb
so I can take a look at it. If so, put it in a zip file
and send it to .
Fons
-----Original Message-----
The main report is grouped by reference number and week
(like [enter period number] & "*").

Each reference number can have entries for each week. The
weeks are broken out into periods of 4 weeks each. So a
reference can have entries for period 6911-1 and 6911-2,

etc.

What I am trying to do is get the subreport to grab all of
the entries for the period entered when the report is

opened.

Right now, all I get is the list for the first week there
are entries for. If there are entries for week 1 and 2 I
am still getting only the week 1's.

I hope that helped

-----Original Message-----
Hi Holly.
You do not give much repoert as to how your report is
setup.
I assume you have a group by the period in your main
report, and the main repoert has date for each of the
periods. Than you have a subreport in the footer for

the
period group, when you run the report the subreport

should
print for each period in your main report.
Come back with some more detail if this did not help.
Fons
-----Original Message-----
Third times a charm, right...


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.

Does anyone have an idea?
.

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.