Importing distinct data to different computers in Access 2000

[TG]

I am trying to set up data in a way so that each of our campuses are
getting data that is only relevant to their campus from our main
database. For example, a campus in Las Vegas would only get the
student information relevant to that campus. How would I set up a
process of importing that relevant data only to that campus and so
forth and to the 6 different campuses we have? Thank you so much!

TG

 

[Frank Stone]

hi,
info is a little sketchy but sounds like you need to set
up 6 querys each picking out the info related to the
campus. Then write a macro with 6 SendObject. you can set
up the email there and email the 6 queries.
anyway, thats what i would do.
hope it helps
regards
Frank