Also posted on Access users Forum. AC2002 using default 2000 format
I have a report based on a query that sorts correctly on lastname and is grouped on the first character of the lastname. The query, a test form all sort correctly. But the report although grouped correctly does not sort correctly. Infact I cannot fathom out the sort sequence at all. Now getting desparate as I need this report tonight & have 1124 records to be verified by the organisation members for accuracy. Any help & advice would be most welcome. Norman Pearce Ealing Hospital ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/