Query multiple fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a report summarizing/listing all the occurrances of a
particular criteria.

For example: I have a form with a subform. The form lists the owner, the
subform lists all the associateted issues along with the responsible party.
For example the subform has fields Sub1, Sub2, Sub3, etc.

I would like to run a query/report that will group the sub with a list of
its issues below it. Something like this:

Sub
issue 1
issue 2
issue 3

Sub
issue 1
issue 2
issue 3

The main sub may appear as Sub1 in one incident and Sub6 in another?

Is this possible?

Thanks
 
Barbara

How you build your query/report depends on how your data is structured.
From your description, I suspect you have multiple fields, one per issue. I
can't be sure, however, because you describe your form, not the underlying
data.

If you have multiple fields, say three, to allow for (up to) three issues,
you have ... a spreadsheet! A more normalized, relational design would have
a single field for issue, and multiple rows, to show more than one issue.
This way, you never run into the "what do I do now?" question when a fourth
issue shows up!
 
Back
Top