Rate calculation based on date range criterium

[Lifeseeker]

Hi,

I have the following code working in Access:


SELECT Count(regular_ct_scan_evidence) AS A, (select count(phn) from tbl_ed_data_collection_record) AS B, A/B AS Rate
FROM tbl_ed_data_collection_record
WHERE (tbl_ed_data_collection_record.Regular_CT_Scan_Evidence)="Yes";

If I want to add one more column to be used as a criteria to specify the time stamp as well, I couldn't do it in query grid. When I tried to run the query, it says....."you cannot execute a query that does not include the specified expression in the aggregate function".

Is there any way around it?

Thank you

 

[gemma-the-husky]

no i dont think so - its an irritation sometimes that you cant just add "info" to aggregate queries - but i think if you are using count - then how could you include date as well?

 

[Lifeseeker]

no i dont think so - its an irritation sometimes that you cant just add "info" to aggregate queries - but i think if you are using count - then how could you include date as well?

Date is for specifying the number of records on each extract.

data collection will be on-going, so for each reporting period we would like to have the analysis done and see what the percentage is like.

So not possible?

Thank you