refrence a report FUNCTION to subreport

[pablavo]

I have a report made up from a mutiple table query.

I have duplicated the query for the subqry and used "Is Null" on one of the fields to display late payments. This has been made into a subreport which is a duplicate of the report. Only difference being the records.

I am using the BETWEEN AND function within a date field in both report/subreport queries so that I can lock down records within a month.

The only thing is the Parameter box repeats twice because of this. Even when I enter the same dates, a warning message comes up saying the expression is to complex or whatever.

Is there anyway to perhaps reference the reports function criteria to the subreport in someway? or maybe there's a differenct way to do this.

Hope someone can help!

 

[boblarson]

Use a FORM for your parameters (have one text box for the "from" date and one for the "to" date) and reference them in the query's criteria. Don't rely on users to have to type out the parameters each time.

With an input form that you create, a user can enter the parameters once and open more than one report without having to type the parameter over and over again; even for the same report which they may close accidentally and then wish to view again.

 

[pablavo]

Thanks

thanks BobLarson! I actually got to work on the form which was what I was going to do at the end and realised that I could link both report and subreport date criteria to the input form which worked nicely!