 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2004Query multiple fields
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!  SignatureMore info, please ... Jeff Boyce <Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.