 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2007Report Question
All, I have a report which is currently sorted by a numerical field, i.e. 1,2,3, & 4, as in a priority ranking. Is anyone aware of an option that will enable me to show only my priority 1,2, & 3s; essentially, excluding the 4s from the report? I would be much appreciative for any guidance.  SignatureH > All, > [quoted text clipped - 5 lines] > the > report? I would be much appreciative for any guidance. How are you opening the report? If you're using DoCmd.OpenReport from within VBA code, you can add a WhereCondition parameter to the OpenReport call to limit the priority: DoCmd.OpenReport "report name", , , "[priority field] < 4" Carl Rapson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.