Search results

Hello, I am creating a database that users will be using to pick dates from. The last time, I created a Yes/No field for each of the dates that were available and the users would use a checkbox on a form to make their selection. I am wondering if there is a better way of getting this done...

This is what my query looks like at the moment: Field: Issue,Rejected,Inspected,Area Total: Group By,Sum,Sum,Where Criteria:,,,[Area:] What I'd like to have is a calculated field after "Inspected" which would show the grand total of all "Inspected" for that "Area". Example: Issue, Rejected...