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. ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hg12n7l/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124389767/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/
