Hi Sharon, Sorry I don't have the time to look at this right now but in your report look at the Grouping and Sorting option under the View menu option on the menu.
Glenn P. Jones -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of sharonme76 Sent: Thursday, 18 August, 2005 12:28 PM To: [email protected] Subject: [AccessDevelopers] Please help! Question concerning forms and reports Hi. I'm trying to "beef up" one of the Access general templates for use, and I'm running into a problem. I'm using the "Contacts Management" template, and have added a field "LoanOfficer" to the Contacts table and as a search item on the "Report Date Range" form, so that I can have a report organized not only by date but grouped by Loan Officer. I hope this makes sense, I am a bit experienced with Access but I've done a ton with MySQL, and thought this would be related. I guess I'm wrong... ;-) Now it looks like the problem isn't in the form, but in the report I'm trying to make. I've updated the database to include dummy entries, so that you can see the lack of organization in the report. If you can help, please download the database 1. Download http://www.sharonedmonds.com/CustMgmt.zip 2. Click "Preview Reports" 3. Click "Preview the Weekly Call Summary Report" 4. Select a loan officer and a date (at least 1 week). 5. The report pops up, organized by person, but it doesn't seem to process the "loan officer" item from the previous form. How in the world do I change this??? I'm so confused... Any help would be greatly appreciated. I've received no help on this in other forums. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hagg3le/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124390551/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> 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/
