Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

MS Access

  1. Nov 6, 2008 #1

    CRGreathouse

    User Avatar
    Science Advisor
    Homework Helper

    I'm trying to make a simple database in Access (to replace an older one in Filemaker), but I'm not sure how to do what I want.

    I have a table of workers, each of which is tied to a supervisor. (At the moment they're both in the same table with a flag to tell supervisors from other workers, but this could change if convenient. The database keeps the same kinds of information on both kinds of workers, so there didn't seem to be a good reason to split them.)

    I want to generate a mail merge with a letter for each supervisor, including information on each worker supervised. Is there a good way to do this?
     
  2. jcsd
  3. Nov 6, 2008 #2

    CRGreathouse

    User Avatar
    Science Advisor
    Homework Helper

    I'm no SQL wizard, but I was able to code the appropriate snippet for 'Row Source' to link each piece of equipment to a supervisor (by their ID):

    Code (Text):
    SELECT [Workers].[Worker ID], [Workers].[First], [Workers].[Last] FROM Workers WHERE (((Workers.[Supervisor?])=Yes)) ORDER BY [Last], [First];
    But to make the (report?) that I want, I'm not sure where to start in Access.
     
  4. Nov 6, 2008 #3
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: MS Access
  1. MS Word (Replies: 3)

  2. Ms Dos (Replies: 4)

Loading...