Query adding dates

[oni1983]

I have a database which is keeping track of all the visits done by a group of monitoring officers. Now I need to create a query to add the number of visits actually done by each monitoring officer. I have used the following:

Name of Field: Sum(IIf([Monitoring Visit 2 Date] Is Not Null,1,0))

This is working in that if the field is empty I am provided with a zero, if a date is inputted in the field I am provided with 1. However when I am trying to add these numbers (I have 6 monitoring visit fields in total), a Parameter Value box is popping up asking me for the same fields.

There are no mistakes in the field titles so that isn't it. What could be the issue?

 

[Joe4]

It sounds like as if it does not recognize those fields as being in your data sources of your query.
Can you post the SQL code for your query, and the exact error message?

 

[oni1983]

Sorry for the late reply! I solved the issue but creating a query on the original query and it worked!!!