Recent content by SatanLuciferJones

Thanks plog, that was easy to follow and gave me the desired results. Thanks again!

I have created a simple count query: SELECT ECapQuery.TestID, Count(ECapQuery.YNavg) AS cnZ FROM ECapQuery WHERE (((ECapQuery.YNavg)=0)) GROUP BY ECapQuery.TestID; However, I would like it to display all of the ECapQuery.TestIDs, even if the count is 0. Is there a way to force the query to...

Thanks for the response. I'm totally new to crosstabs, I only started experimenting with them yesterday! But how would I go about doing what you suggested?

The picture shows more clearly my dilemma, but I'll try to explain. I have roughly 10,000 sets of data and an if statement in a query that yields xW, xE, or xN, where the x is c, l, d, or s. I created some crosstab queries to count the number of each in each group. The problem is that for DWEN...

How would I go about making a sub query? Never mind. I figured out how to make the sub query. Thank you so much. I really needed this because some other queries I have use too many DLookups and it was really slowing things down.

Hello, About Me I know there has to be a better way to do what I'm doing, but I'm a beginner at Access, so I don't know exactly how to do it. I'm using Access 2010. About My Setup I have a parent table (Tests) that gives general information about a particular product and child table (SubTest)...