Select data to populate a report by GROUP

[Frank]

Hi,

I have an ID table and a GROUP table. Both tables are keyed on ID#. The
GROUP table is a list of "On/Off type" fields. One ID# can have one or more
GROUP fields toggled on.

How do I build a query to populate a report that will be grouped by GROUP
(if an ID# belongs to several groups then I need it to appear on the
report... in each of it's respective GROUP(s).

 

[Allen Browne]

There are several problems making this harder than it needs to be.

For starters, GROUP is a reserved word in JET SQL, so may give you problems
as a table name.

Secondly, using lots of yes/no fields is not the right way to store this
kind of data. For details and an alternative, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html

Once you have the right data structure, it will be very easy to create the
report.