Is there anyway a query field can reference what is in the fields of a
Yes. In the criteria of your query field, put
Also, even if I were to do this all using seperate queries, how do I
get the form to display the totals?
You can do this in the query itself or you can have a field on the form
perform the calculation. If you do it in the query, you will need to
use Totals. Click View, Totals. Then in the column you wish to add
up, put Sum in the Totals row for that field. You would then simply
add that field to your form. If you do the calculation on the form
itself, you would make a new textbox and put =Sum([YourFieldName]) in
the control source.
Hope that helps!