X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Multiple Records With Text Values Shown On Same Report, Access 2016    
post Aug 28 2019, 10:30 AM

Posts: 23
Joined: 5-July 11

Basically I have various text values based on different criteria that I'd like to show on a report, but with multiple records shown side-by-side. I've attached a picture with what I mean specifically. I'd like to know if this is possible, and if so, if you can point me in the right direction or provide a brief description of how to create it. I'm in the early stages to where I could design my tables and queries in any way to help achieve this. I feel like it's not as simple as putting sub-forms side-by-side in a parent report.

Thanks in advance!
This post has been edited by cacrank: Aug 28 2019, 10:31 AM
Attached File(s)
Attached File  Report_Example.JPG ( 96.43K )Number of downloads: 7
Go to the top of the page
post Aug 28 2019, 10:40 AM

Access Wiki and Forums Moderator
Posts: 76,425
Joined: 19-June 07
From: SunnySandyEggo

Hi. Maybe with enough planning and a lot of code, this is possible. However, it might be simpler to just automate Excel to generate a spreadsheet that looks like your report.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Aug 28 2019, 12:03 PM

UA Admin
Posts: 35,898
Joined: 20-June 02
From: Newcastle, WA

Perhaps a crosstab query could be designed to put three records into columns that could work. It's hard to say without seeing sample data as it is now stored in your existing tables.

My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    23rd October 2019 - 08:50 AM