Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    21

    Unanswered: How hide value on report if certain criteria exists

    I have a report which lists records sorted by part number and then by date. Also on the report for each record is an inventory qty. So the first record may show part #1 due 1/31/2010 and display an inventory qty of "5". If the next record on the report is for the same part number, regardless of the due date, I want the inventory qty to display "0". I realize this is a little strange but it has to be displayed this way. I can't just hide dupes because the next record for an entirely different part number may need to show the accurate inventory qty.

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Not sure I fully understand but you may want to look at the Onformat event for the section in the report.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Mar 2008
    Posts
    21
    To further explain...

    The report now looks like:

    Part # Due Date FG Qty
    12345 1/31/2010 1
    12345 2/10/2010 1

    Any I want it to look like:

    Part # Due Date FG Qty
    12345 1/31/2010 1
    12345 2/10/2010 0

    Note the "0" because the FG Qty is already shown in the first record which is for the same part number. In other words, if the part number is the same, replace whatever qty is in FG Qty with a "0".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •