More info

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

Dennis

I have a crosstab query that allows me to run a report for
all the years in the database. I have developed a form
that allows me to put in "starting year" and "ending
year". When I use that form in a query, I get the years I
want (for example 1998-2001). I want to run a report
using that query. I don't want to hard code the years in
the report. I want to use the years from the form. The
report would have a variable number of years and the years
would change from report to report.
 
Dennis,

If I understand correctly you have a query that returns
the results you want (only the years you have on your
form). Base your report on this query and all should work.
Be sure the form is open and has the desired years entered
when you run your report.

HTH,

Terry
 
Did a report based on query. Get a message "the Microsoft
Jet database engine does not recognize " as a valid field
name or expression". Any suggestions? Thanks.
 
Back
Top