Subreports with counts

[GinaWhipp]

In the meantime, this will work...

 

[vbaInet]

Obviously CanWest is ignoring my comments, but I'll say it for the 3rd and last time and then unsubscribe from this thread. The JOIN needs to be changed to show the Addiction category.

 

[CanWest]

Obviously CanWest is ignoring my comments, but I'll say it for the 3rd and last time and then unsubscribe from this thread. The JOIN needs to be changed to show the Addiction category.

I am sorry. I did not intend to ignore you. I thought I had replied and stated the error that happened when I tried that. I looked back and there was no reply from me. I truly do apologize, I obviously did not hit the submit button

 

[vbaInet]

That got your attention. I'm still here don't worry

Did Gina sort it out? Or did you manage to change the join?

 

[GinaWhipp]

@vbaInet

The JOIN type could not be changed because there were no Addictions that were Active. (It was the very first thing I tried on the initial sample.) Sorry I should have said so!

 

[vbaInet]

It's not your fault Gina
I could be missing the point but this is what I get in the attachment.

 

[GinaWhipp]

I got that too when I changed the JOIN but those figures include Active and Closed and the OP only wanta Active, hence, the Temp table which only hold Active. The other table holds all.

 

[vbaInet]

@GinaWhipp, just had a look and I see what you mean.
I looked at the report and didn't see any change to the count and since you didn't mention the query you made "qryCountAllDisabilities" I was unsure what changes you made.

 

[GinaWhipp]

@vbaInet

I figured the OP would catch it right way as soon as they looked.

 

[CanWest]

@vbaInet

I figured the OP would catch it right way as soon as they looked.

Ok call me dumb. What is an OP.

So I checked out your sample and saw that you used two queries, yhis allowed for the join to be changed. So I decided to apply this to my existing query(s) to see if I could duplicate your work on my files.

It worked. Sort of.

The addictions category did show a count of 0, but the Category beside the 0 was blank. All the other category names show up but not the Addictions on.

Any clue as to what I am missing?

 

[GinaWhipp]

OP = Original Post/Poster

I have no idea what you are missing. Wait which Table are you drawing the Category names from?

 

[bob fitz]

"OP" is a two letter acronym that is often used here. It means "Original Poster".

 

[vbaInet]

My Oxford dictionary tells me it means Original Post (or Poster) as suggested by Gina.