From the course: Microsoft Access: Forms and Reports

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Build a report from a query

Build a report from a query

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Build a report from a query

“

- [Instructor] Building a report off of an existing query is probably the easiest way to get a great looking report that displays some fairly complex information from your database. By leveraging the power of queries and feeding their results into the reports record source, you'll create a good foundation from which Report Design becomes just a matter of dragging and dropping fields into the appropriate locations. I've said this before about Access, but sometimes all of the wizards and the automated object creation features of the program can really just get in the way and make things seem more complicated than they really are. Once you understand what's going on behind the scenes it's often the case that hand built from the ground up, really is the way to go. For this exercise, I've gone ahead and pre-built a query that totals up our Customer's Lifetime Sales. This query returns a row for each individual customer and it…

Contents