sum of records on a subform

K

Kevin

I'm creeating a database to generate project estimates/bids. I have a multi
tab subform. One tab has the general bid information, and another tab
contains the details of the bid. On the "details" tab, there are 2
calculated fields (calculated in a query): LineCost & SellPrice.

I would like to bring the total of those 2 calculated fields into a box on
the "general info" tab. It would serve as a sort of summary, giving the
bid's current total. The Record Source for the "general info" tab is a
different query. Where do I start? Can I refer to more than one Record
Source for a subform?
Any help is appreciated!
 

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

add control to a subform - Sum of records 1
cmbo box on subform fills fields on form when chkbx is yes 2
Create a SubForm on a Tab Control 0
subform record source tabbed page 2
Auto generate bid number in a form 12
VBA to page down in a subform 2
getting subform information 2
if a # then sum, if text leave null 2

Top