Hiding a section of report if fields are even

[JeffreyDavid]

I have a detailed report that has 2 grouping levels, WO# and Part #, each WO can have numerous Part#'s. Each detail line has Estimated Qty, Actual Qty and Under Issued Qty for each Part#. If the total of the Actual Qty and Under Issued Qty is equal to the Estimated Qty, I need to hide that section of the report.
If this is posible, how would one go about doing so?

 

[RichO]

Which part of the report do you want non-visible if those conditions exist? Just the single detail line containing that information?

 

[JeffreyDavid]

Which part of the report do you want non-visible if those conditions exist? Just the single detail line containing that information?

Yes, I just want to hide the single detail line when the Actual Qty and the Under Issued Qty are equal.

 

[RichO]

The easiest way to do this is with a query. Is the record source for your report already a query or is it a table?

In your first post you said if the total of the Actual Qty and Under Issued Qty is equal to the Estimated Qty you don't want it to show, then in the last post you said when the Actual Qty and the Under Issued Qty are equal so I'm not sure which one you need.

If it's the first one, in the Estimated Quantity field, enter the criteria:

<>[ActualQty]+[UnderIssuedQty]

The query will only return the records where the Estimated Quantity plus the Under Issued Quantity is not equal to the Estimated Quantity, so the unwanted rows will not even be brought into the report.

 

[JeffreyDavid]

The easiest way to do this is with a query. Is the record source for your report already a query or is it a table?

In your first post you said if the total of the Actual Qty and Under Issued Qty is equal to the Estimated Qty you don't want it to show, then in the last post you said when the Actual Qty and the Under Issued Qty are equal so I'm not sure which one you need.

If it's the first one, in the Estimated Quantity field, enter the criteria:

<>[ActualQty]+[UnderIssuedQty]

The query will only return the records where the Estimated Quantity plus the Under Issued Quantity is not equal to the Estimated Quantity, so the unwanted rows will not even be brought into the report.

Sorry about that, the first post is correct, I want to hide the line in the detail section if the Actual Qty and the Under Issued Qty are equal.
Where in the Estimated Qty field would I put the criteria '<>[Actual Qty] + [Under Issued Qty]'?

 

[RichO]

You would want to do this in the query. Each field in a query has a criteria box and this is where you would put that expression.

If your report's record source is currently a table, set up query to read the records from that table and change the record source to the query.