I have a form with two different subforms inside. The subforms have multiple selections.
I would like to create a report that has the fields of the main form and all the selections from the subform as 1 entry on the report. Is this possible?
Right now, when I make the report, it shows each subform selection as a separate entry on the report.
What I would like to do is this:
The main form has 1 company field. And the subform could have unlimited selections of items. I would like the report to show 1 company with all the sumform selections in 1 entry only. Right now it duplicates the company field for as many as there are subform selections.
I don't mean to be rude, but that won't happen in Access.
Having said that, I qualify that blanket statement by saying that if you are willing to invest a lot of time programming (VBA is probably your better vehicle, rather that queries upon queries) and concatenating the various sub-info into one long comma-separated string, and putting the result into a new table which you would then use for your report's Record Source, you can make it happen.
In Access, all separate info is displayed vertically, like you have it in your "Not Like This" scenario, not horizontally.