Check box count from subdatasheet

[stephenrussett]

Ok here is what i am trying to do.

In my query i have a subdatasheet. Within my subdatasheet have check
boxes. In the query (top level) i want to have a count of the check
boxes that are checked yes.

so:

Query1:
Column1 Column2:
A001 2

Subdatasheet:
Column2 Column3
001 Yes
002 Yes
003 No

So, the subdatasheet would be part of "A001". Query1:Column2 is
showing that 2 check boxes are selected for the subdatasheet data of
A001

I cannot seem to make the query show the Query1:Column2 data

Anyone know how?

 

[stephenrussett]

Ok here is what i am trying to do.

In my query i have a subdatasheet.  Within my subdatasheet have check
boxes.  In the query (top level) i want to have a count of the check
boxes that are checked yes.

so:

Query1:
Column1            Column2:
A001                       2

Subdatasheet:
Column2          Column3
001                     Yes
002                     Yes
003                     No

So, the subdatasheet would be part of "A001".  Query1:Column2 is
showing that 2 check boxes are selected for the subdatasheet data of
A001

I cannot seem to make the query show the Query1:Column2 data

Anyone know how?

No one has an idea?

 

[KARL DEWEY]

Post the SQL for your queries.