Join Adam Wilbert for an in-depth discussion in this video Calculating fields, part of Access 2007: Forms and Reports.
The data for your reports comes from the Record Source property, and it's linked…to either a table, an embedded query or in the case of our LifetimeSpend report,…from a linked query.…We can actually calculate values right here in our report as well using…Unbound text boxes.…So we can bring in data that isn't in the Record Source.…I'm going to double-click and open up my LifetimeSpend report that we've been working on.…So far we've got some layout in and we've got some Conditional Formatting saved.…Let's go ahead and change into Design View.…What I would like to do now is add in another level of information to our report by…summarizing data within each state.…
What I'd like to do is get a total count of how many customers we have in each…state and the sum total of all of the sales within the state.…To keep things clean, we'll add a State Footer and place all of our…calculated fields there.…We'll need to turn on our Group & Sort panel to add the footer.…I'll go to my on Group StateName, the More section, and I'll turn without a…
- 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
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. The User Experience
- 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.