counting in access on a make table query (was - Counting yes/no fields)

[Allison1]

Hi!

I have a problem with the counting in access on a make table query - can anyone help?

I work for a recruitment company, and have a table for the vacancies we raise. I then have a table linking to this where you can record the candidates submitted for each role. The 'CVSubmitted' and '1stInterview' are a check box yes/no. I now want to run a query where I have a sum of the total number of CV's and 1st Interviews for each role, which I can't seem to do! I've tried a few options that I've seen on the internet but having no luck.

If anyone can help - that would be awesome! Thanks

 

[IAccess]

Hi,

Make one query to select the data you need. Then construct the make table query based on the first query. In the second query you can do a iif(isnull([some_field]),0,[some_field]) to handle those pesky nulls.

J.D.