How to count data from another query by date

[Brian62]

I have a query that is used to pull data to the report by between dates to include writeups and yes, no, and N/A's per question (combobox). Works great.

I created another query to pull the totals of yes, No, and N/A's by column off of that query. Here is one example of one of the questions..

Code:
Doc28-51No: Sum((Abs([Doc #28-51]="No")))
Doc28-51Yes: Sum((Abs([Doc #28-51]="Yes")))
Doc28-51NA: Sum((Abs([Doc #28-51]="N/A")))

I created another query off of this query to total the yes, no and n/a to place at the report footer by sub-report from this query giving me the totals I need. It will pull all the column totals but not by the between dates I need.

Code:
Total No: Sum([Doc2No]+[Doc25No]+[Doc12-5No]+[Doc28-51No])


I need the query to pull by the between dates from the report query when I enter it in.

Is there a way that this can be done. I hope I explained it well enough...

[ajetrumpet]

brian,

check out the responses on the AWF forum

[Brian62]

Adam,

Where is that forum? I can't find it anywhere.

Thanks, Brian