Union of query with blank information

[Huddle]

I have two query's. One that shows a list of buildings with post inspection dates "Q_PI_Qrtly_Insp_Ct_Range_Count" and one that shows a list of buildings that all have posts "Q_PI_Qrtly_Insp_Ct_Range_Blank". What I am trying to do is create a union of sorts that will give me a list of all the buildings with the count of the post inspections performed and if there were no post inspections performed then list those buildings with a zero or blank. Even if I have to have two seperate lists that would be OK but I can not figure out how to get a list of buildings where no post inspections were performed. I've attached a sample of the database. In other words my "Q_PI_Qrtly_Insp_Ct_Range_Blank" query doesn't work.

[JoeM]

I cannot download open your database from my present location, but here is how I have approached problems like this in the past.

1. Do you have a table of just all the buildings you want to return? If not, create a query that returns each building you want to see exactly once.
2. If you have not already done so, create a query which returns a count of all the post inspections (grouped by building)
3. Create a query, doing a LEFT JOIN from the object in step 1 above, to the object in step 2 above (this will return a record for ALL buildings)
4. Create a calculated field to return the count using the NZ function to return a zero in the instance of no match, something like:

Post_Inspection_Count:NZ([Total_Inspection_Count],0)+0

I think that should give you what you are looking for.

[Huddle]

That worked just fine. Thanks