Query for overdue refunds

S

SJL

I have a query which works out time refunds take to be processed fields:
ID and Days Elapsed. Query Name Refunds.
Can someone explain to me in "Dummy" terms how I can create a query based on
this that will show me the percentage of refunds that are processed outwith 5
days? The " Days Elapsed" is calculated as days. I asked before, but am not
familiar with the "Select" entry.
Thanks
 
M

[MVP] S.Clark

A percentage is the part / whole. p / w = %

p = Count(Refunds within 5 days)
w = Count(All Refunds)

1. To get P:
a. Calculate the number of days per refund(DpR). qryDaysPerRefund
b. Using qryDaysPerRefund, group the records by "Within 5 days" and "Not
within 5 days", and count the occurances. qryRefundsGroupedByCategory

2. To get W:
Calculate the total number(count) of refunds. qryRefundsCnt

3. To get %
Using qryRefundsGroupedByCategory and qryRefundsCnt, perform the
percentage calculation.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
 
Top