I am a beginner and have been given the assignment of creating a
spreadsheet
in 2003 Excel that will get info from a Access database. Is there a way
to
set up a spreadsheet to fill in the info below by year by department:
Spring: John Smith
Summer: Jane Smith
Fall: Kerrie Smith
from a database query that has the information of name, term (spring
etc.),
year, department. The boss wants this to update automatically every time
she
opens the workbook. I have no idea how to even start this project.
Thanks!
--
Teresa
Norfolk Southern
Roanoke VA
