Query trouble

[vladi16]

I have a table, tbltests that has the following fields: testnumber and
rulename. It is a storage type table where I list all of the tests we
perform on our employees.
I have a form, fmTOs, that we use to input all the tests we perform on our
employees it includes the date and time the test was performed, the test
number and rule name that was performed, the employee etc. All of this input
goes to a table, tbltretests.

I have created a report, rptTestCount, from a right join query, qryTestCount
with the following fields:

testnumber.tbltest
rulename.tbltest
testnumber.tbltretests (Count)

The query & report come out as intended… I see all of the tests numbers and
their matching rule name… and I get the count of how many of each was
performed. What I can’t seem to figure out is how to add the testdate field
from tbletretests into the query to allow myself to be able to filter records
between start and end dates.

Ultimately, once I get the query situated, I want to open my report,
rptTestCount, from a form where I enter two dates and presto… the report
appears. I now know how to do the form; I just need help with the date issue.

 

[Arvin Meyer [MVP]]

Use and Aggregate (aka: Group By or Totals) query.

Group By tbltest.testnumber
Group By tbltest.rulename
Count tbltretests.testnumber

Where testdate >= #12/1/08# And <= #12/26/08#