Selective results in a Report?

  • Thread starter Thread starter Davíð Þórisson
  • Start date Start date
D

Davíð Þórisson

hi,
this should be sooo easy but I cannot find out how to do it...
My database is for my clinic where doctors receive fees for writing reports
for insurance companies. So the fields are Doctor.Name, Paper.Price and
Paper.Date. The report should simply iterate totals based on 1) Doctor.Name
and year from Paper.Date and the footer shows the sum for all entries
displayed.
I would like to have on the top a simple input field or combo box where the
user could filter the results by the doctor's name and year. So how do I
insert a form into the report? Or do I have to attach the form to the Query
criteria but then, how can the user easily refresh the Report's data without
closing it and opening again?

Thx!
David
 
I would like to have on the top a simple input field or combo box where the
user could filter the results by the doctor's name and year. So how do I
insert a form into the report? Or do I have to attach the form to the Query
criteria but then, how can the user easily refresh the Report's data without
closing it and opening again?
Click to expand...

You're making it harder than it needs to be!

Base your Report on a Query. The Query should reference unbound form
controls by using

=Forms!NameOfTheForm!NameOfTheControl

as criteria. You can put a command button on the Form to open the
report; it will search the tables using the selected criteria.

You will certainly need to close and reopen the Report in order to
change its data; a Report is a static snapshot of the data in its
recordsource query as of the time the report is opened, and is
intended for printing rather than for onscreen display. But if you
keep the form open it would be easy for the user - close the report,
change the criteria, click the button.
 
thx John, this works fine like this. Just needed to have confirmed that
Reports are static!
 
Back
Top