I need to come up with an SQL query that counts the number of occurrances that a number in TWO fields occurs in a table. I have been fighting with it all day and have yet to come up with a working query. I am fairly certain that I need to use a subquery to achieve this, but cannot seem to get it to give...