I am using a field as in the "Issues" template in Access 2007 that displays 
the history of the field "Comments".  The general function of recording and 
displaying all the old comments is working fine.  The only thing I'd like to 
change is to either append each new comment to the front of the 
"ColumnHistory" instead of the end, OR figure a way to at least display it 
newest to oldest instead of the oldest on top/first.

It seems the default is to append data only to the end/bottom.  The problem 
with that is that the first comment in the list is the oldest comment and 
when the list is larger than the display box then the user must always scroll 
down to see the newest past comments.

any ideas?

Just reverse the concatenate statement.  

If you do not understand then post the SQL/code statement so it can be 
edited for you..
-- 
KARL DEWEY
Build a little - Test a little


"mbaycura" wrote:

> I am using a field as in the "Issues" template in Access 2007 that displays 
> the history of the field "Comments".  The general function of recording and 
> displaying all the old comments is working fine.  The only thing I'd like to 
> change is to either append each new comment to the front of the 
> "ColumnHistory" instead of the end, OR figure a way to at least display it 
> newest to oldest instead of the oldest on top/first.
> 
> It seems the default is to append data only to the end/bottom.  The problem 
> with that is that the first comment in the list is the oldest comment and 
> when the list is larger than the display box then the user must always scroll 
> down to see the newest past comments.
> 
> any ideas?

I'm, not sure how to get to the SQL code since this is being run through an 
expression in the control source that calls the ColumnHistory method in 
Access 2007.
here is my expression though.

=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

"Comments" is a text field.  My table is "Ideas" which will also work in 
place of [RecordSource].

I don't mind leaving the whole columnhistory thing behind if there is a 
programming way too.

"KARL DEWEY" wrote:

> Just reverse the concatenate statement.  
> 
> If you do not understand then post the SQL/code statement so it can be 
> edited for you..
> -- 
> KARL DEWEY
> Build a little - Test a little
> 
> 
> "mbaycura" wrote:
> 
> > I am using a field as in the "Issues" template in Access 2007 that displays 
> > the history of the field "Comments".  The general function of recording and 
> > displaying all the old comments is working fine.  The only thing I'd like to 
> > change is to either append each new comment to the front of the 
> > "ColumnHistory" instead of the end, OR figure a way to at least display it 
> > newest to oldest instead of the oldest on top/first.
> > 
> > It seems the default is to append data only to the end/bottom.  The problem 
> > with that is that the first comment in the list is the oldest comment and 
> > when the list is larger than the display box then the user must always scroll 
> > down to see the newest past comments.
> > 
> > any ideas?

Having used the Issues database within a larger database, I now find that, while I want to keep using the history section within the Issues part, I would like to delet the passed content from the history section.  So far I can't find a way to do this and maintain data rcords for the rest.

I'd be grateful for any suggestions.

RE

EggHeadCafe - .NET Developer Portal of Choice 
http://www.eggheadcafe.com