View Single Post
  #3  
Old July 26th, 2007, 01:52 PM posted to microsoft.public.access.reports
AuditorCMM
external usenet poster
 
Posts: 39
Default Date Prompts in Subreport

Excuse my inexperience, but could you elaborate on that or provide an
example? I'm not sure exactly what you mean. Thanks!!

"Duane Hookom" wrote:

IMHO, parameter prompts should never be used. Consider kicking your
application up a notch and replace prompts with references to controls on
forms.
--
Duane Hookom
Microsoft Access MVP


"AuditorCMM" wrote:

Is it possible to combine 2 reports together if they are both based on
queries that require date prompts?

The reason I am asking is that I have 2 reports of employee time, each for a
different department. Both are based on queries that have the criteria
Between [Beginning Date:] and [Ending Date:]. That way, when each report is
generated, the user can select the date range to display. Now, I am trying
to combine them so that they both show up on the same report. I tried making
one a subreport of another, but when I try to run the report, I keep getting
the date prompts over and over again and the report won't generate.

You have all been such a great help to me in the past, so any help you could
give would be much appreciated! Worst case scenario, I'll just have to make
my manager run 2 separate reports.

Thanks!