Dan Waters
dwaters at usinternet.com
Wed Feb 4 16:02:01 CST 2009
You might try 3 or 4 stacked queries. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Wednesday, February 04, 2009 3:44 PM To: Access Developers discussion and problem solving Subject: [AccessD] Sorting in a report I have a report with 4 columns. The user wants the data sorted by the second column and then by the first column then sorted by the third column and the first column and then by the third column and the first column. I can get ti to sort by the second then third then fourth column but I cannot see how do do a subsort of the first column for ech of the other three column sorts. Hope this makes sense. Or do I need to use three sub reports? Thanks. Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com