View Full Version : order report by name not id


miki
02-24-2002, 06:26 AM
Hello.
I sorry about my poor english ;(

I have a report when it's open the user can select which field order the report,
my problem is the all field it's ID and not [A-Z] how i can order report by [A-Z].
(i use combo to see [A-Z]and not id by hide column)

Thanks.

jwindon
02-24-2002, 06:57 AM
You need to bring the NAME field into a query and sort that ascending then base your report off that query and the selection you made on your form. That would mean bringing the table that contains the names into the query grid.

Hope that helps.

miki
02-24-2002, 07:49 AM
Thank you jwindon,
but maybe there are different way.



[This message has been edited by miki (edited 02-24-2002).]