create a form to enter report criteria

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I have a database with muliple years. I have been able to
develop a form that allows me to enter a beginning year
and an ending year for a query. I have been unable to to
link the query with a report. Any suggestions? Thanks
 
"Link the query with a report?" I don't understand.

You can put the query in a global variable, or in a control on your form and
pick it up in the Open event of the Report, or you can use a Query without
the WHERE and supply the WhereCondition in the DoCmd.OpenReport that you use
to open the Report.

If followup or clarification is needed, please do so here in the newsgroup,
not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
Sorry for the lack of clarity. I'm new at this.

I have a database with ten years of data. I want to be
able to print a report using some, but not all of the
years. I've develop a form, that allows me to
input "starting year" and "ending year". How do I use
that information to make a report? How do I make a report
that allows the "year" columns to be a variable? Some
reports might have three years, some five, and the years
will change report to report. Also, is there some way to
pick non-consecutive years? I might want 1990, 1995,
2000. Thanks for any suggestions!
 
Back
Top