Is there a way that I can count the amount of times an item has been selected from a Combo Box in a number of records. The purpose of this is to enable me to turn that information into a chart.
ComboValueField is the name of the field in your table where you store the value chosen in the combobox for each record i.e. the control source of the combobox on your form, not the name of the combobox.
If you are still struggling, if you post your database I'll be able to write the query with your field names etc.
OK the name of the Table is Technical_Incident_Report1 the name of the field within the table that will hold the value is Fault. Therefore as I read it I should be writing this:
SELECT Technical_Incident_Report1.Fault, Count(1) AS Count
FROM Technical_Incident_Report1
GROUP BY Technical_Incident_Report1.Fault;