K
kp
Access 2002. Db built on Access 2k. Currently at 262 MB.
I have built 6 queries from 6 different tables. The subject matter for each
is different, otherwise the tables and queries are virtually identical.
However, 1 query will not sort dates in descending order. I have gone over
and over the table and query and can find nothing that makes it different
from the other 5 for this particular field...yet it absolutely will only
leave the dates in ascending order. If don't tell it to sort at all, they
are in ascending order. If I tell it to do ascending order, it remains in
ascending order.
Any ideas?
I have built 6 queries from 6 different tables. The subject matter for each
is different, otherwise the tables and queries are virtually identical.
However, 1 query will not sort dates in descending order. I have gone over
and over the table and query and can find nothing that makes it different
from the other 5 for this particular field...yet it absolutely will only
leave the dates in ascending order. If don't tell it to sort at all, they
are in ascending order. If I tell it to do ascending order, it remains in
ascending order.
Any ideas?