Sending data from a form to a report through a query

[bfamo]

Working on a little project at work.
We have a database in which we register alot of information about measurements we do. We grade each measurement between 0 and 70, and these grades is put into the database together with the date that the measurement has been done.

What I basically want is a report that counts all the measurements which have grades between 0 to 40, within a determined period of time.

To illustrate my problem, I have made an example of what I'm thinking the finished result would look like.

First off, I have a table where the information is stored:

This forms the basis for the report.

Then, you open the form "FrmSelectYear" and select for which year you want the report to count:

When you press the button "View Report" in the form, the report runs a query that collects and counts all of the grades between 0 and 40 given in 2003, and shows it in a report called "RptShowResults".


I have been trying alot of differen approaches, but I guess my sql and report skills are not what it should be...

I have made a query that just collects all of the values/grades and the belonging dates in the whole time period. Then, a second query counts the grades.
From here I have been trying to link the query to the form and report but I cant seem to find a solution.

Anyone who can give me some tips on this one?

thanks alot!

 

[dhookom]

Isn't this the same question you posted in "Access Queries and JET SQL". If so, please end this thread and just keep one going.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]