LLEW1
04-19-2009, 07:27 PM
Hi,
not sure Im able to achieve this one, tried a few things but here goes.
Looking to cause the record results of query to appear side-by-side, not sequentially oned under each other. So from the query - qryPhases the subject field is Phase and will be either Phase1, Phase2 etc.... .
Currently no problems in getting the result but as normal, the results appear sequentially under each other as seperate record when in continuous form view - as expected.
What Id like though is to have the results appear horizontally side-by-side. The attached image might help show what Im after, has an 'as is' and 'to be' concept. I know what Im looking for is not a native method of how records are shown in Access, but with some ingenuity thought it might be possible.
Ive considered creating seperate forms or reports for the result and place these as sub form/report, but still cant get for each record to appear side-by-side. Thought page layout in columns might be the trick - but no success the way I tried it (pby reflection of my lack of use of columns in Access rather than it not being possible).
Query works fine - this is just a question on how I can force the layout on either a form or report to present this way.
Any thoughts appreciated.
not sure Im able to achieve this one, tried a few things but here goes.
Looking to cause the record results of query to appear side-by-side, not sequentially oned under each other. So from the query - qryPhases the subject field is Phase and will be either Phase1, Phase2 etc.... .
Currently no problems in getting the result but as normal, the results appear sequentially under each other as seperate record when in continuous form view - as expected.
What Id like though is to have the results appear horizontally side-by-side. The attached image might help show what Im after, has an 'as is' and 'to be' concept. I know what Im looking for is not a native method of how records are shown in Access, but with some ingenuity thought it might be possible.
Ive considered creating seperate forms or reports for the result and place these as sub form/report, but still cant get for each record to appear side-by-side. Thought page layout in columns might be the trick - but no success the way I tried it (pby reflection of my lack of use of columns in Access rather than it not being possible).
Query works fine - this is just a question on how I can force the layout on either a form or report to present this way.
Any thoughts appreciated.