Hi there
Im creating a call centre database, in which the "leads" table is linked to the "calls" table, so that many calls can be made per "lead or company".
I now have a "results" table, which only needs three fields: "Yes", "No", or "NotAvailable"
Each time I create a "call" for a company or lead, I need to be able to select the "result" or outcome of the call, (yes, no or n/a)
That works out fine. But now - I need a query which will give me totals for all the "yes"'s all the "no's" and all the n/a's in order to print monthly, and weekly reports which also need to calculate the "closing ratio" of the call centre
I tried creating 3 fields in tblResults - YES NO N/A and then using tick boxes, but when I do a sum it doesnt calculate them?
Please help :-)
Thank you kindly
AccessFreak