Using a forms filter string to filter query (1 Viewer)

Hi,

I have a database recording the results of chemical tests on cement.

I have a form called frmFilter, where the controls allow me to select the parameters and the filter works perfectly. It generates the code strWhere, much like here:
http://allenbrowne.com/ser-62.html

Now I need to be able to perform calculations (averages, min, max, standard dev, etc...) on these results.

I think I need to be able to pass this strWhere or some field on the form to a query so i can then perform the calculations on the filtered results. Is that so? or is there an easier way?
If so, so far I've got: (qryCement is the query thats pooling all the related fields together)

SELECT *
FROM qryCement
WHERE (((qryCement.tblCement_cementID)=Forms!frmFilter!cementID));

But, this only returns the first result of the filter, and not all of them.

Cheers,
Ali

Yes you have to transfer the strWhere into the query to get the same results...

Thanks for the confirmation, but I don't actually know how to do that...

Any help on how to do that would be great?

Currentdb.Querydefs("QueryName").SQL = "Select ... from ... " & strWhere