Putting Contacts into Classes (1 Viewer)

[lovelylauralin]

I have a database with all my contacts in one table... Banks, Realtors, Contactors, personal, Etc..

I want to be able to somehow label each contact so that I can run a report and only pull all phone numbers that are contractors, or realtors, etc.. but still have one large base with all my contacts..



How do I go about doing this without creating mulitiple tables?

 

[lightray]

You need a field in your table like ContactType which says what type of contact they are. If you already have one - easy
Create a query where ContactType = "contractor" etc and all relevent details.
Base your report on this. could even use it as input parameter
lightray