MS Access

  • #1
CRGreathouse
Science Advisor
Homework Helper
2,824
0
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?
 

Answers and Replies

  • #2
CRGreathouse
Science Advisor
Homework Helper
2,824
0
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:
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.
 

Related Threads on MS Access

Replies
2
Views
1K
Replies
1
Views
4K
  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
12
Views
3K
  • Last Post
Replies
2
Views
6K
  • Last Post
Replies
4
Views
2K
  • Last Post
Replies
1
Views
17K
  • Last Post
Replies
16
Views
2K
  • Last Post
Replies
1
Views
9K
  • Last Post
Replies
17
Views
9K
Top