Question about including null data

Everyone,



I'm trying to make a query to return payroll data, but I'm not sure how to get Access to return 0 where data doesn't exist for a particular month.



For example, imagine this table:

Name Month Hours

John 1 160

John 2 160

Dave 1 160

Dave 2 160

Matt 1 160



How would I get this ouput:

Name Month Hours

John 1 160

John 2 160

Dave 1 160

Dave 2 160

Matt 1 160

Matt 2 0



If anyone has any suggestions, I'd greatly appreciate them.



Thanks!

Question about including null data