R
rarmont
I designed an Access 2007 employee database that only has certain authorized
users so not everyone can get on it. Here's my problem: since switching over
to the database, we no longer update our archived spreadsheet with the
current employees' phone numbers, so my administrative staff is repeatedly
asking me for a current list. I created a query and ran a report, which is
OK for now (I need to format the print layout a little different, I have it
sorted by district, then department, then LName and FName, right now when it
prints - two columns per page - the first district is on the first page and
the second district starts on the first page then continues on the second
page and the third district starts in the middle of the second page and goes
on to print three or four remaining cells on a third page, plus the header
prints across the first page but only across half of all pages after that),
but I need to find out if there's a way to create a file that all of my
employees can open and print that updates every time the file is opened.
I've imported the query and linked it to excel and it updates how I want it
to fine but I lose the format from my report.
Any suggestions?
users so not everyone can get on it. Here's my problem: since switching over
to the database, we no longer update our archived spreadsheet with the
current employees' phone numbers, so my administrative staff is repeatedly
asking me for a current list. I created a query and ran a report, which is
OK for now (I need to format the print layout a little different, I have it
sorted by district, then department, then LName and FName, right now when it
prints - two columns per page - the first district is on the first page and
the second district starts on the first page then continues on the second
page and the third district starts in the middle of the second page and goes
on to print three or four remaining cells on a third page, plus the header
prints across the first page but only across half of all pages after that),
but I need to find out if there's a way to create a file that all of my
employees can open and print that updates every time the file is opened.
I've imported the query and linked it to excel and it updates how I want it
to fine but I lose the format from my report.
Any suggestions?