G
Guest
I'm working on my first Access database and don't know if a lookup is
appropriate for what I want.
I'm creating a social/legal services directory listing over one
organizations by field of law. The goal is to create hardcopy report that can
be given out to the community. The trouble I'm having is that most agencies
need to be listed under several fields of law and I can't figure out how to
set up the report (or the underlying query) so that the report will list each
field of law and then all of the applicable agencies in alpha order.
I have a table set up with all of the agency contact info as well as all of
the fields of law. I can't figure out if these should be two tables or one
and either way how I set up the query/report so that the final product sorts
the agencies by field of law in a way that any agency that works in multiple
fields of law shows up under each category.
Thanks in advance for any help!
Kat
appropriate for what I want.
I'm creating a social/legal services directory listing over one
organizations by field of law. The goal is to create hardcopy report that can
be given out to the community. The trouble I'm having is that most agencies
need to be listed under several fields of law and I can't figure out how to
set up the report (or the underlying query) so that the report will list each
field of law and then all of the applicable agencies in alpha order.
I have a table set up with all of the agency contact info as well as all of
the fields of law. I can't figure out if these should be two tables or one
and either way how I set up the query/report so that the final product sorts
the agencies by field of law in a way that any agency that works in multiple
fields of law shows up under each category.
Thanks in advance for any help!
Kat