|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 16th, 2007, 04:44 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Hide all detail based on criteria
I have a report that shows a list of issues for a certain project sorted
first by EquipmentID (in EQID header) Then by Date (in Detail section) each date has a certain issue with criteria of Created, Recheck or Corrected. I need to print only the active issues. Ex... on xDate an issue is created for a certain pc of equipment this means it is active, I need to print: Project ******************************************** EquipmentID ******************************************** xDate Issue Created ================================================== ================= xDate the issue is Rechecked, I need to print: Project ******************************************** EquipmentID ******************************************** xDate Issue Created xDate Issue Recheck ================================================== ================== xDate the issue is Rechecked, I need to print: Project ******************************************** EquipmentID ******************************************** xDate Issue Created xDate Issue Recheck xDate Issue Recheck ================================================== =================== xDate the issue is Corrected this means it is inactive, I need to print: Project ******************************************** ******************************************** ================================================== ==================== One Project will have many EquipmentID’s Can anyone help me? Thanks K Board -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200708/1 
|
|
#2
August 16th, 2007, 04:45 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Hide all detail based on criteria
babyatx13 wrote:
I have a report that shows a list of issues for a certain project sorted first by EquipmentID (in EQID header) Then by Date (in Detail section) each date has a certain issue with criteria of Created, Recheck or Corrected. I need to print only the active issues. Ex... on xDate an issue is created for a certain pc of equipment this means it is active, I need to print: Project ******************************************** EquipmentID ******************************************** xDate Issue Created ================================================= ================== xDate the issue is Rechecked, I need to print: Project ******************************************** EquipmentID ******************************************** xDate Issue Created xDate Issue Recheck ================================================= =================== xDate the issue is Rechecked, I need to print: Project ******************************************** EquipmentID ******************************************** xDate Issue Created xDate Issue Recheck xDate Issue Recheck ================================================= ==================== xDate the issue is Corrected this means it is inactive, I need to print: Project ******************************************** ******************************************** ================================================= ===================== I can do all steps except the last one. One Project will have many EquipmentID’s Can anyone help me? Thanks K Board -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200708/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
