Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / September 2005

Tip: Looking for answers? Try searching our database.

Keeping records out

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony - 29 Sep 2005 18:47 GMT
Is there code that if you have a record that you do not want in the report to
keep it out of the report?  Example, I have a personnel database that I print
a phone list from and I want to keep employees that are no longer with the
company in the datbase but, do not want them to print on the phone list.  I
am going to use checkboxes to tell which employees are active and inactive.  
Does any one have any ideas on how I who do this?  Thanks in advance!!
RobFMS - 29 Sep 2005 18:58 GMT
Create a column in the table that is a Yes/No datatype. Call the field
"InActive". If the person is such, then select the column.

On the report source (or query), include the column "InActive" and specify
the criteria as "Where Not InActive" (which translates out to: showing all
records where InActive = False).

HTH

Rob

Signature

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/

> Is there code that if you have a record that you do not want in the report
> to
[quoted text clipped - 6 lines]
> inactive.
> Does any one have any ideas on how I who do this?  Thanks in advance!!
 
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.