company directory

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a directory for a large company via an Access report.
Most of the information for the directory is stored in a database. However,
there are some items that are not stored in the database (i.e., listing of
conference rooms and their phone extensions, phone numbers for security,
etc.).

The report would be grouped by office location, then department, then list
the employees in that department. My question is: how do I get the misc.
entries into the report? Do I need to create a separate table to house that
information? Or can it be inserted in the correct place via code?
 
I wish I could. Everything needs to be in alpha order, and grouped by office
location. They currently have the directory like this:

ORLANDO OFFICE
ACCOUNTING:
(list of employees in that dept. from table)
COLLECTIONS:
(list of employees in that dept. from table)
CONFERENCE ROOMS:
(bunch of crap not in database)
FAX NUMBER:
(go figure this one, since it's already in the report header)
INFORMATION TECHNOLOGY:
(list of employees in that dept. from table)

You get the idea. What do you think?
 
Well then, the various items need to be in your table.

Add a new field to your table. A checkbox. Make it "misc" or "other" or
similar. Check that box for all the weird entries and then make all your
other forms, reports, etc exclude those entries where you only need real
employees.

Personally, I have a "type" field where I include a "Misc" type and then I
include/exclude those from various reports and forms.
 
Thanks so much for your help! I've literally lost sleep over this. I'll
give it a shot, but be forewarned that I may be back with more questions :)
 
Back
Top