C
ConnerS
I have a database in Access with Parent database and
Parent volunteer event subdatabase. Data is entered into
the subdatabase using a form in frontpage. That works.
The Parent table is supposed to add up all the individual
events and show cumulative hours, which it does when you
run the query in Access. My question is etiher
1. How can I make the query run automatically within
Access every time the subdatasheet is updated, or
2. How do I get the data access page from Access to show
the data from the database (I can open the page, but only
the title of the page shows), or
3. How can I get the parent datasheet to show the sum of
a field in the child datasheet.
Parent volunteer event subdatabase. Data is entered into
the subdatabase using a form in frontpage. That works.
The Parent table is supposed to add up all the individual
events and show cumulative hours, which it does when you
run the query in Access. My question is etiher
1. How can I make the query run automatically within
Access every time the subdatasheet is updated, or
2. How do I get the data access page from Access to show
the data from the database (I can open the page, but only
the title of the page shows), or
3. How can I get the parent datasheet to show the sum of
a field in the child datasheet.