By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,508 Members | 1,823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,508 IT Pros & Developers. It's quick & easy.

Report sub form filter

P: n/a
Hi,

The db I'm trying to update has a report form from which all other
statistical forms and reports are selected/printed by dept, type, cost,
number etc. The report form uses a date filter to generate the
necessary data and you can also addtionally filter by by individual
department/s, supplier/s if you so wish which is great

However, I'm trying to develop an individual statistical form that for
one subform uses the date filter as mentioned above) to show a sub set
of the total items for a department in the selected time frame and on
an adjacent subform shows the total number of unclosed actins/items for
the same department. By way of example, if for the date range 1/6/6 to
30/6/6 the number of items is 19, yet the full number of open items for
the same dept is 55. BTW, if I remove the code for the date range, I
get the second subform showing what I want, but obvilusly no items for
the date range.

The way the filter works now, I can only ever show in either subform
the number of items for the date range. How can I filter on the first
subform the items for the date range and on the second, the toal number
of unclosed items? The code for date range is included below.

If Nz([StartDate]) = 0 Or Nz([EndDate]) = 0 Then
MsgBox "A From and To date must be entered", vbCritical, "Must define
dates"
Else
DoCmd.OpenForm "stats"
End If

Any and all suggestions welcome.

Peter Morris ;-)

Jul 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.