Hello,
I wasnt sure how to word this right. I am NOT trying to make an Access Object table.
I am trying to create a 5x5 table in a form similar to what I created below.
**************
Year 1 ______________ Year 2_________________ Year 3 Class ______________
Year 1 Year 2 Year 3 Total
Asian
Hispanic
White
Total
*************
This table runs of a query I made. And the “Start Date, End Date, and Class” fields are the criteria linked to my query. I am able to get the total rows and columns without any difficult by using the method below for each class.
=DCount("[Class]","qryUniversity","[Class] = 'Science'")
=DCount("[Class]","qryUniversity ","[Class] = 'Math'")
=DCount("[Class]","qryUniversity ","[Class] = 'Biology'")
=DCount("[Class]","qryUniversity”)
I input this code into the control source of the fields in my form.
I am having difficulty with everything else. First of all, is there a way I could the making my Query know that when I enter “2016” under txtYearOne, I actually mean “>=1-1-16 and <=12-31-16”?
Secondly, how can I get DCount to count values based on TWO criteria?
Would I do something like this:
=DCount("[Class]","qryUniversity","[Class] = 'Science' “[txtYearOne] = “2016” ")
(Blue refers to my query and red refers to the criteria of my query)