How do you pull summary info into a form??

[PQTIII]

On a form all daily production stats for drilling are entered based on 20ft and 40ft drilling. After the dailys are entered I want to be able to show month to date information totals for the number of 20ft and the number of 40ft holes drilled for the month in two different display fields. I also need to be able to use those fields for calcs on the same form. How do I pull the summary for 20ft and 40ft holes info into text fields on that form?

Thanks
Paul

 

[spizotfl]

take a look at dlookup, that may get you what you want

 

[PQTIII]

Not too experienced with dlookup. The query I have "drilled" with the field "depthcat" contains 20ft or 40ft designation. I want to show the sum of the field "drilldepth" for each; all 20ft holes and one for all 40ft holes. How do make the dlookup work for what I need?

Thanks
Paul

 

[PHV]

In fact I guess you need to learn the DSum function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886