Calculations in a Query

[gselliott]

We want to work out whether we have met our deadlines or not.

Currently we have a Fix By Date field and a Date Completed field. We want to be able to work out the number of calls that were completed within time against those that were not, ideally we want to display these figures as a Percentage to import into a graph.

How do we go about this using a query?

Any help would be appreciated.

Thanks

 

[jtvcs]

If I'm catching what you need, you would want to utilize the TOTALS capability of a query to summarize your data. You would proabably want a Group by field and the Count(s) on appropriate field(s). If done successfully, this query can probably be the source for yur graph. HTH jt