Help!!!!!!! Please!!

[fenerfan]

Hey Guys,
I need help with a little acces project I am doing, I need to query a table for those items which are out of date (if expiry date is before current date) annd get the total count of these out of date items, then i need to get the percentage of : total out of date items /total number of items

AnyOne????

 

[fenerfan]

AnyBOdy?????????

 

[KeithG]

Can you post an example DB?

 

[fenerfan]

Here is the table: description

Mech_Procedures
(ID, Procedure Number, Issue Date, Expiry_Date, Reviewer)

I need a query to return all IDs where (expiry Date < system Date) (I know How to do this part)

But I need to also have a count for the total expired, and be able to have tis as a percentace of the total rows in the table.

Thanks..

 

[Rich]

Divide the Count of expired records by the Total number of records in the table