enhancing parameter based queries

J

jpo

I've inherited a DB that allows a user to input a unique member ID and then
create a report detailing the last 10 financial transactions. After the user
enters the ID via a form, a command button allows the user to run a series of
parameter queries run which then create tables. These tables are the basis of
the report.

The current DB works fine. However, a manager now wants to be able to input
a user group ID and then create a report for every member of that group. Does
anyone have an idea as to how this can be accomplished?
 
K

KARL DEWEY

Add the groupID field to the table and populate. Add the field to the query
for the report. Add a criteria to the field like --
[Enter GroupID]

Add the GroupId to the report.
 
M

[MVP] S.Clark

First, you would have to assign each member to a group. So, a group table,
and a matching foreign key column in the member table.

Next a query to extract those members in a group. Query the new column for
the desired group id.
 
Top