Sharon, Take a look at the SQL for your report adding the field "LoanOfficer" from your table contacts and tying that to [Forms]![Report Date Range]![LoanOfficer] should give you the results that you were looking for.
Mike --- In [email protected], "sharonme76" <[EMAIL PROTECTED]> wrote: > 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=12h1456dn/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124394052/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/
