Add a Text Box to a Report Showing the Result of an Unrelated Query

[astaff4]

I am very new to Access, so I will try to be as detailed as possible....

I am working on a report that shows a running roster of all the incidents my office tracks that occurred this year in 2013. Currently there are two versions of the report. One runs off of the main table where the records are kept and filters on opening to only show 2013 cases. The other copy runs off of an existing query that isolates 2013 cases for a separate database function.

I am attempting to add a box at the bottom of the report (either copy as long as it works) in the report footer that shows the number of incidents we had by this point in 2012. I thought I could do this by creating an unbound text box and typing a formula into the control source. However I haven't been able to figure out the formula. I did manage to create a query that pulls the records I want to count by using the criteria

 <DateAdd("yyyy",-1,Date())) and >#2012/01/01#

.....but I can't figure out how to count those records from an unbound text box on an unrelated report.



Any help would be greatly appreciated as I am stumped.

[June7]

Could try domain aggregate function. I don't know the structure of the 2012 query but maybe like:

=DCount("*", "queryname")

[astaff4]

Thank you for taking the time to answer.
That worked! I had tried to use the domain aggregate function before but I had used the expression builder and clicked on the field which ended up writing the function as:
=DCount("*",[queryname]![fieldname]) instead of =DCount("*","queryname")
Now I feel silly, thank you again for your help!