From the course: Building Solutions Using Excel and Access 2019 Together

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Build reports on your new queries

Build reports on your new queries

From the course: Building Solutions Using Excel and Access 2019 Together

Start my 1-month free trial

Build reports on your new queries

“

- [Instructor] We typically do a lot of work that eventually ends up in our reports, and sometimes we just want to show a quick PDF of any report that we're writing. So let's go build a new report on our queries. Let's go double-click OrdersByCustomer. And again this has the parameter value and we want to be able to write a report on this but let's just run it one more time. I'm going to type Hook and I want to look at their 2018 orders for the first quarter so I'll do 1/1/2018, and 3/31/2018. I'll go ahead and click okay. Awesome now this just looks like data, but I want a report that actually shows me the customer and then groups up their order dates and then sums up their order amount so. A report format's really easy to do that, and when I deliver this out it actually gets delivered as a PDF so I'm going to go ahead and save this. I'll go to Create and I can capitalize on the report wizard here. And because I'm on OrdersByCustomer it defaults so I'll go ahead and bring in Customer…

Contents