hi there,
I don't necessarily know how to explain what I am trying to do but maybe someone out there has the correct terminology and answer.
I'm working on a database with some basic contact information. We are currently manually updating about 10 different versions of contact lists in MS Word for our organization. This is obviously a huge time waster in duplicate entry and such, not to mention the amount of cross checking and potential missing or inaccurate information is quite high. The database is setup and I'm now working on the reports.
the data I'm looking to report on now is stored in two tables currently
table 1
building name, address, phone, fax
table 2
employee name, building name (links back to table 1), extension, home phone, cell phone, job title
the report I want to create would include the building name, phone, fax as the heading
then the detail would include the employee name, ext and job title.
Kind of like this
Building Name
Phone # ,,,,,,,,,,,,, Fax #,,,,,,,,,,,,
employee name ext jobtitle
employeename 2 ext 456 my job title
empl name 3
the problem is there is so much wasted space on the report that I would like to report multiple locations across the page such that there would be two or more building names across the page
ie Building 1 Building 2 Building 3
see attached word doc for an estimation of what I am looking for.
is there a way to do this in Access. if so how.
Any assistance than can be provided is greatly appreciated.