This is more of a just curious type of post:
Can details be grouped in a form like they can in a report?
I have contractors that I am wanting to display based on criteria from an unbound form. There are some contractors that belong to multiple categories and this causes extra records to be displayed. I believe it would cause confusion if the end user is going through the results and sees the same contractor appear two or three times in a row.
The category is the only part of the contractor information that is changing, so basically I am trying to figure out a way to display all the possible categories at once instead. There are 12 fields being displayed on the form currently and I know reports have limits to the amount that can be shown on them.
It's possible I could be trying to show too much at once but at the same time I want to keep the number of reports/forms/queries down as much as possible because I'm lazy and don't want to put forth the work to create them.
Can details be grouped in a form like they can in a report?
I have contractors that I am wanting to display based on criteria from an unbound form. There are some contractors that belong to multiple categories and this causes extra records to be displayed. I believe it would cause confusion if the end user is going through the results and sees the same contractor appear two or three times in a row.
The category is the only part of the contractor information that is changing, so basically I am trying to figure out a way to display all the possible categories at once instead. There are 12 fields being displayed on the form currently and I know reports have limits to the amount that can be shown on them.
It's possible I could be trying to show too much at once but at the same time I want to keep the number of reports/forms/queries down as much as possible because I'm lazy and don't want to put forth the work to create them.