Total of a subset of records reported to a box on a form

G

Guest

I want a box that will look at another box on that form then find all the
instances of that entry in a table then total all the entries in another
field on that table and report it to the box.

Ex. If box1 = X and reports its entry to field y in table1 then find all
the records in t table1 that have X as an entry in field y then take that
subset of records and add up the entries in field z and report that total to
the box I am creating.

I am doing this for error checking.
 
G

Guest

Not sure that what you are looking for, in the control source of Text box 2
you can write

=DSum("Z","Table1","y='" & [TextBox1Name] & "'")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total only specific records on a continuous form 2
Calculating a text box 9
Show a count of a field in a text box on a form - JCW 1
Using DSUM to get running total on a filtered form 0
Form defaults to a different record when updated. 2
Access Command button to look up and copy data from a query to a table 0
Form Filter off of a combo box, only on existing entries 3
total checked boxes on a form 2

Top