I have a simple database--one table with these fields: Date, Route, Total Contact, Total "Yes", Total "No"
I want to calculate the percentage for the Total "Yes" and Total "No" fields based on the Total Contact for a date range.
I have a query that is calculating the percentages for each item in the table using this calculated field
PerCent: [Total Yes]/[Total Contacts]
But when I try to create a query to do the same calculation using the sum of Total Contact, Total Yes and Total No, I get a prompt box asking me to input the parameters. What I have typed into the [ ] brackets in the calculated cell appears in the prompt box and if I hit RETURN the calculated cell is blank.
Do you know what I'm doing wrong?