From the course: Microsoft Access Essential Training (Office 2021/LTSC)

Unlock the full course today

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

The Report Wizard

The Report Wizard

From the course: Microsoft Access Essential Training (Office 2021/LTSC)

Start my 1-month free trial Buy for my team

The Report Wizard

“

- [Instructor] In the order details report that we just created access placed a single line for each record that was coming out of the original query. Now, as I take a look at these details, I really can't figure out what order these lines are placed in. They look like they're alphabetized based off of the product name, but if you scroll through this report you'll see that's not quite the case. These records also aren't ordered based off of the last name or the first name of the customer or the date that each order was placed. So we could go into this report and adjust the sequence that each row appears in, but that's not the only thing that we can do. What if I wanted to completely restructure this data? What if I wanted to see all of the details for each customer, including their name and their phone number, and then below each customer's entry, I'll get a listing of each of the orders that they've placed. We can…

Contents