Count Text as Number

[AccessFreak]

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

[ajetrumpet]

what are you looking for? 3 columns, each with the sum of the appropriate values?

if so, you can do that like so:

select dsum("yes", "results"), dsum("no", "results"), dsum("na", "results")