> I'm not sure if I'm approaching this the right way but here
 > goes...
 > I have a client list database and a workorder database. I would
 > like to
 > be able to put a table in the client db that shows their history
 > (prior
 > workorders). I can do that just fine with the Table tool as long
 > as I
 > leave it in the default ASCENDING order - meaning it will list the
 > FIRST
 > job to newest rather than the MOST RECENT to oldest (which is the
 > way I
 > need it listed). What is the best way to do this? Through a query?
 > Will
 > it update the list as I add records or will I have to keep running
 > new
 > queries? Can I do some kind of sort that will let me do it an
 > easier
 > way? Thanks!
The easier way is to create a form or report and use the group band to sort 
on date in descending order.  If you want to use a query, you can have the 
query calculate the difference between the date and 12/31/99, and sort the 
answer table on that field in ascending order.
Rich
---
(1:125/9)
---------------