Reverse chronological order

C

Cheese

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!
 
S

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)
 
J

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
 
C

Cheese

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create timeline with event being hyperlinks to documents on drive 1
Track Changes Timestamps in Chronological Order 1
Track Changes Timestamps in Chronological Order 2
arranging dates in chronological order 3
Comments 1
how to reverse the paragraph order in a word document ? 1
How do you get Outlook to send emails in the right order? 2
Combo Box question 5

Top