Reverse chronological order

[Guest]

Hi,

I would like to edit a form and a report that currently are ordered by entry
date in chronological order to reverse chronological order so that the user
is seeing the last entry first. Can you assist? Thanks!

 

[Steve]

Create a query based on the table where your form and report get their data.
Sort desacending on the entry date field. Use this query for the
recordsource of your form and report.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Jeff Boyce]

Not sure how this is a "tablesdbdesign" newsgroup question...

If you haven't done so already, create a query against the underlying data
(table). Then base your form and your report on the query, not the table.

Now, reverse chronological is easy! Just modify the query to sort the way
you want it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks. I will be more vigilant in reviewing the categories for
questions...I thought this was for "generic Database design questions"