Keeping records out

[Guest]

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]

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

--
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/