Hide all detail based on criteria

  • Thread starter babyatx13 via AccessMonster.com
  • Start date
B

babyatx13 via AccessMonster.com

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
 
B

babyatx13 via AccessMonster.com

babyatx13 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top