Is there a way to create an input form and report that scrolls / displays from left to right rather than top to bottom?

rogerdjr
rogerdjr used Ask the Experts™
on
Is there a way to create an input form and report that scrolls / displays from left to right rather than top to bottom?

I want to show and input to

Pay App 1  |  Pay App 2 | Pay App 3

rather than


Pay App 1

Pay App 2

Pay App 3

where Pay Apps 1-3 are rows in a table
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Not really.  But you can create a subform and display multiple copies of the same subform side by side on your main form, and then filter each of them to display only the correct records. That is what I do with calendars.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Sure,
Select the table in the navigation pane
Select: Create-->Forms-->More Forms-->Multiple Items

Just note here that your fields have repeating names:
Pay App 1
Pay App 2
Pay App 3
...This is a sign that your design may not be properly "Normalized"...

JeffCoachman
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
You said:
"where Pay Apps 1-3 are rows in a table "

Let's be clear, ...are these "Fields" (Field Names) or values in a field?
...or something else...?

Author

Commented:
Pay apps 1-3 are rows with multiple fields per row

See attached tabler report and the spreadsheet I'd like to emulate
doc_rptObjects.rtf
columns-form.xlsx
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Then continue working with Dale on this, ...I was presuming that these were individual fields...

Author

Commented:
THanks

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