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