Query Join, Expression, or Code

[catguy]

My brain is fried!
I have a query with 2 tables (tblX and tblY) that are joined by the "Reported" field. Table X contains the fields "Reported", "Count_of_X" and "Created". Table Y contains the field "Reported".
The join properties are "All records from tblY and only those from tblX that match", there is also a Where clause with a date range. It appears the date range may be the culprit.
If there are no records for "Count_of_X", then there will be no records for "Reported" when the query executes.
What I want to do is, if there are no records for "Count_of_X", I would like to have the "Reported" field return a record at execution and the "Count_of_X" field return a value of "0" (zero), regardless of the date range.


I have an Excel template that will be pulling the data from this query, but if the "Reported" fields do not match the template fields, the "Count_of_X" data doesn't align and everyone gets mad.
I'm fairly comfortable with VBA and expressions, but this one has me stumped. Any help would be greatly appreciated!!!! Thanks

[ssanfu]

You are right. When you set the date criteria, you restrict the dataset from tblX "Reported" to only 1 & 2. There are no 3's within the date range.