It's unclear to me whether you are trying to "group" by loan officer or "limit" the report results to one loan officer, sorted by date. I can't look at the database itself because I only have Access97 here at work.
It looks like you have two responses already, one suggesting the grouping and sorting options for the report, and one suggesting using the loan officer selection from the form as criteria in the query your report is based on. That probably didn't help much, but can you clarify which you are trying to do? Thanks, Toby ----- Original Message ----- From: "sharonme76" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, August 18, 2005 9:28 AM 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=12hpc16hd/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124395900/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
