Dlookup and sum

  • Thread starter Thread starter nybaseball22
  • Start date Start date
N

nybaseball22

Hello. I have a form that sums amounts from a query on the form. I
am trying to add some new fields that come from a different query to
the same form. Does anyone know if this can be done? In other words,
I want to have some fields calculate sums from one query, and some
fields calculate sums from a different query.

I appreciate any help. Hope you have a nice weekend.

Thanks
 
Hello "nybaseball22".

am trying to add some new fields that come from a different query
to the same form. Does anyone know if this can be done? In other
words, I want to have some fields calculate sums from one query,
and some fields calculate sums from a different query.
Click to expand...

When using DLookuo or DSum, simply create a textbox and set the
control source property appropriately.

When using the Sum function in the footer of the form, you will
have to modify the record source of the form to also include the
data from the other query.
If this makes no sense, then you can create two separate forms and
display them as subforms of a main form.
 
Back
Top