You are here:

Using MS Access/MS Access Report Detail Alignment

Advertisement


Question
I have tried to find a solution to my particular situation and have had some glimmer of hope but nothing that directly pertains to my situation.

Here is my dilemma:

I have an Access Report that I want a subreport to pull in the DWG Revision and display it as a bottom to top display vs top to bottom:

ie (THIS IS WHAT I WOULD LIKE TO SEE)
__________________________________________________ _____
_ -
_ -
_1 -
_0 FC FLC 02/07/13 ISSUED FOR DESIGN -
_REV BY APP DATE DESCRIPTION -
----------------------------------------------------------------------

Currently the subreport displays:

__________________________________________________ _____
_0 FC FLC 02/01/13 ISSUED FOR APPROVAL -
_1 FC FLC 02/07/13 ISSUED FOR DESIGN -
_ -
_ -
_ REV BY APP DATE DESCRIPTION - -
------------------------------------------------------------------------------

Any ideas?

Best Regards,
Jason W. Buda, P.E. I Jacobs I Electrical I  I

Currently on Temporary assignment in Jacobs Lakeland Office  

Answer
Sounds like you need to just sort the records in the subreport in reverse chronological order. Add a date/time field representing the date the records were added (or even just use an Autonumber ID field) and then sort the subreport using that field, in descending order.


Be sure to visit my web site and watch my FREE 90-minute Microsoft Excel Video Tutorial

Cordially,
Richard Rost
599CD Computer Training

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.