Hi All,
The form for this problem is much more complicated but I will try and keep it simple to explain what I want to do.
I have desinged a chemical spray diary for a vineyard where the spray event is entered (single form), then linked to the event the blocks are entered (continuous form). On the continuous blocks form (by way of access trickery) I have embedded another continuous form to hold the chemicals applied to each block. By clicking in the particular blocks record you can view its chemicals. Mostly the chemicals will be the same applied to all listed blocks in an event but sometimes a chemical makeup might be different for one or two blocks. This part all works really well.
The problem comes in creating a report to represent all this. I can get reports to present the data that groups an event then lists each block with its applied chemicals (this is long and repetitious if the same chemical mix has been applied to all blocks).
I can get a report to present data that groups events then lists the blocks sprayed and the first chemical mix applied to the first block ( this is Ok if the chemical mix is the same for all blocks). This report is good 'cos its much shorter but could be innaccurate if the tank mix is altered on a particuluar block.
What I would like is a report that groups chemical mixes when they are the same and lists the blocks for that mix. I think I need to group by a group of records or hide a duplicate group of records. I don't know if this is possible.
My reports are made up of three subreports - one for the event, one to list the blocks and one to list the chemicals applied to each block.
Any thoughts appreciated.
Rachael
The form for this problem is much more complicated but I will try and keep it simple to explain what I want to do.
I have desinged a chemical spray diary for a vineyard where the spray event is entered (single form), then linked to the event the blocks are entered (continuous form). On the continuous blocks form (by way of access trickery) I have embedded another continuous form to hold the chemicals applied to each block. By clicking in the particular blocks record you can view its chemicals. Mostly the chemicals will be the same applied to all listed blocks in an event but sometimes a chemical makeup might be different for one or two blocks. This part all works really well.
The problem comes in creating a report to represent all this. I can get reports to present the data that groups an event then lists each block with its applied chemicals (this is long and repetitious if the same chemical mix has been applied to all blocks).
I can get a report to present data that groups events then lists the blocks sprayed and the first chemical mix applied to the first block ( this is Ok if the chemical mix is the same for all blocks). This report is good 'cos its much shorter but could be innaccurate if the tank mix is altered on a particuluar block.
What I would like is a report that groups chemical mixes when they are the same and lists the blocks for that mix. I think I need to group by a group of records or hide a duplicate group of records. I don't know if this is possible.
My reports are made up of three subreports - one for the event, one to list the blocks and one to list the chemicals applied to each block.
Any thoughts appreciated.
Rachael
