report that represents empty fields

[pyromaniac]

Hello,

I’m new to Access so please don’t hate me. I did look for a solution but wasn’t sure what I was looking for.

I have a table with a bunch of lessons on them. In it, I have 8 vehicles and 6 lesson types. I am trying to generate a report that tells me how many are discussion and how many are computer based, they do not care about the other 4 on this report. I couldn’t figure out how to get the counts in one query but I did get it in 2. The problem I am running into is that some of the vehicles have neither or has one and not the other. It seems to only be reporting the ones that are represented in all 3 fields.

So let’s say I have 8 vehicles, 7 are discussion and 6 are computer based. My report will only report on the 6. I need the other fields represented but don’t know how. It doesn’t matter if it is null or a 0 or a blank spot. I just need all 8 vehicles represented on the report.

Any of you have any idea on this?

-Thanks

 

[JHB]

Could you show some sample data, (in Excel or MS-Access database) and also the result you want. Zip it, then you haven't post 10 post yet.

 

[pyromaniac]

Sorry for the late reply. The wife wouldn't let me do work on the weekend and made me do yard stuff . I can't give you what I am working on but I did strip the DB and add car names in replacement. There is a lot of abbreviations that some one here knows what they mean but the only ones I am concerned about in this one is the lesson type and MDS (vehicle model).

heads up, it's messy. I went into this having never used access and it shows.

I included a image in the zip of what I have reported so far and what I want it to look like.

Thanks for your help. Let me know if you need more clarification.

 

[pyromaniac]

looking through my query results, it looks like that may be the issue. I guess I need to make them offer 0 in what they put out.

 

[JHB]

Is the below (picture) what you're looking for, (I think it is)?
Open the report "lessonType subreport" in the attached database.