Access Report - Display Data Horizontally

Bridget Hodkin
Bridget Hodkin used Ask the Experts™
I have a database providing bid options to clients. Every bid has a "GOOD-BETTER-BEST" option - always. I want to display the data on the report with the headings on the far left and then the "GOOD-BETTER-BEST" data across horizontally... kind of like a slot machine. I have tried a cross-tab query and it will not allow me to show all the details the way we need to. Please help or advise if this simply is not possible in Access 2016
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Can you provide an example of what the data looks like in your table, and how you want it displayed (maybe a screenshot of a spreadsheet)?



Pretty simple design request sample; I can get all of the data onto a query, but the problem is displaying the data in 3 columns rather than 3 rows like access wants to do with the detail.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial