Thanks for the email. I would like the report to be limited to one loan officer.
Back to attempting to catch up on recent emails... Thanks again :-) Toby Bierly wrote: > 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 > > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > ------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers>" on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------------------------------------------------ > ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12huau2ep/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124396237/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/
