Show Oldest Record First in subForm

[Daniel]

Hi Guys

I have a subform that I want to show the oldest record first in. ie 3/10/08
before 1/1/07

I have tried using the order by section in the properties tab of the subform:
" IssueHistory.Date DESC" IssueHistory being the table and Date being the
Feild.

However this has not worked. Thanks for any help I recieve!!!!

 

[AccessVandal via AccessMonster.com]

Try to rename the control and the table field name "Date".

Date is a reserved word in access. Maybe access was trying the set the order
base on your current date on your computer.

 

[Arvin Meyer [MVP]]

Rename your fate field or make sure that you surround it with square
brackets [Date]. What specifically, doesn't work when you sort Descending?

 

[Daniel]

Hi

Saddly that did not work

 

[Daniel]

Hi Arvin Myer

The Brackets did not work either. It is not sorting the records in
descending order. They are sorted ascending order

Rename your fate field or make sure that you surround it with square
brackets [Date]. What specifically, doesn't work when you sort Descending?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi Guys

I have a subform that I want to show the oldest record first in. ie
3/10/08
before 1/1/07

I have tried using the order by section in the properties tab of the
subform:
" IssueHistory.Date DESC" IssueHistory being the table and Date being the
Feild.

However this has not worked. Thanks for any help I recieve!!!!

 

[AccessVandal via AccessMonster.com]

Give us the details of the recordsource of the subform, any order clause?.

You might need to set the OrderByOn to True, did you?

 

[Douglas J. Steele]

Your requirements ("show the oldest record first in. ie 3/10/08 before
1/1/07") contradict one another. 3/10/08 is NEWER than 1/1/07, which means
you shouldn't be using DESC in your sort.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Arvin Myer

The Brackets did not work either. It is not sorting the records in
descending order. They are sorted ascending order

Rename your fate field or make sure that you surround it with square
brackets [Date]. What specifically, doesn't work when you sort
Descending?

Hi Guys

I have a subform that I want to show the oldest record first in. ie
3/10/08
before 1/1/07

I have tried using the order by section in the properties tab of the
subform:
" IssueHistory.Date DESC" IssueHistory being the table and Date being
the
Feild.

However this has not worked. Thanks for any help I recieve!!!!

 

[Arvin Meyer [MVP]]

Sorting ascending shows the oldest record first (1/1/07).
Sorting descending shows the newest record first (3/10/08)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi Arvin Myer

The Brackets did not work either. It is not sorting the records in
descending order. They are sorted ascending order

Rename your fate field or make sure that you surround it with square
brackets [Date]. What specifically, doesn't work when you sort
Descending?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi Guys

I have a subform that I want to show the oldest record first in. ie
3/10/08
before 1/1/07

I have tried using the order by section in the properties tab of the
subform:
" IssueHistory.Date DESC" IssueHistory being the table and Date being
the
Feild.

However this has not worked. Thanks for any help I recieve!!!!