Join Adam Wilbert for an in-depth discussion in this video Calculating fields, part of Access 2010: Forms and Reports.
We've seen how report stay connected to a data source through the record source…property, which is linked to either a table, an embedded query or in the case of…our lifetime sales report a linked query.…But we can actually calculate additional values right here inside of our Report…using unbound text boxes, let's go ahead and right click on our Lifetime Sales…report and open it straight into the Design View.…What I would like to do is add some calculated fields that add up the number of…customers inside of each state and then adds up a total value that each state is…brought to the company, we can do that with two text boxes and we could do that…in a site footer section.…
We'll go up to our Group & Sort button here on the ribbon, I'll turn that on and…for StateName where it say More I'll open that up and over here on the right,…right now it says without a footer section I click the down arrow and change…that to with a footer section.…That'll add a new section here called StateName Footer that will appear after every state.…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Appropriate for all
Setting Up a Database in Excel 2010with Dennis Taylor43m 23s Appropriate for all
1. Introduction to Forms
2. Form-Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. Printing, Tweaking, and Automating
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.