Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Conditional Count part 2

    I have a field [Tipo] from a table [Rotulos]
    the [Tipo] field the values; PAGO, BONO, LIBRE, RSVD
    and another field called [CodProducto] with Values; VACIO, SUI

    i have made a count of the amount of each [Tipo] in a report with a Dcount

    =DCount("[Tipo]","[Rotulos]","[Tipo] = " & Chr$(34) & "RSVD" & Chr$(34))

    i need to now count the RSVD from [Tipo] where [CodProducto] != "VACIO" OR "SUI"

    how can this be done?

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    You can use " AND " to add another criteria to domain functions.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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