Recent content by Guinfan

I have a query that is working, almost. There are a few items in "MOI" table where the value is 0. When I run the query, those items are not showing up. I would like for them to show with a value of 0. I used the design wizard to make the query. I was hoping someone could go through the SQL...

OhioSteve, I do want Nulls treated as 0s. Basically, if my query returns nothing (no females in a company) then I want the query to return a 0. That way I can use that query in other queries and use it for reports.

Here is the code for the query SELECT tblCompanyInfoTest.Company, Count(tblRecruitInfoTest.RecruitID) AS CountOfRecruitID FROM tblGender INNER JOIN (tblCompanyInfoTest INNER JOIN tblRecruitInfoTest ON tblCompanyInfoTest.Company = tblRecruitInfoTest.StartingCompany) ON tblGender.Gender =...

There is no SQL statement, that I know of. I'm working in access 2002 and setup a query using the design view. As for the rest of your posts, thank you very much, but I have one question, where do I put that code? As you can tell, I'm not very good with this and am learning as I go. Thanks again.

I've created a querie that sometimes returns a null if there is no relevant data. I think it's a null as there is no info showed, just the "headers" of the columns. Anyway, I need it to show a 0 (zero). Anyone know how I can do this? Thanks