Stupid Question

[claddagh]

Hi guys,

I have a bit of an embarrasing question, as I`m sure that this is so easy to solve, but its just beyond me...
I have searched but dont get exactly what I`m looking for, looked in all my books to no avail !!!!!

I have a form, which had many data in it.
I have a particualr feild "cust_ref" which is sorted A-Z (asscending)
How would I change this to Z-A (descending)
I have done all the changes in my tables, queries etc, but this doesnt effect the form..
I also have the same problem in one of my reports....

Im sure its really simple, but I think i`m over complicating the solution, and its now giving me a really bad headache.

Thanks guys.

 

[MStef]

Hello claddagh!
Look at "DemoSortingZAA2000.mdb"

Form; Look at properties "Order By"
Report; Click on icon "Sorting and Grouping".

 

[claddagh]

Fixed

MStef,

Thanks very much for that.
Worked just like you said it would.

You think something so basic would be covered in my books, but there is no reference to the DESC bit that has fixed my problem.

The report has also been sorted.

Once again, thanks very much.

Max

p.s. This forum is def the best access forum that I have ever come across.
The users are very polite, helpful, and I have always had an answer within 30 mins of posting a question.

You just cant beat this place.
Keep up the good work guys, and I soon hope to be good enough to pass down some tips and tricks that I have picked up recently and return some useful help to other uses like I have been given instead of just Posting Questions.

Thanks once again to everyone who has helped my with my problems.
Much appreciated.