G
Guest
I have a Sum query based on the "Cycle Info" table.
I am comparing the number of cycles in which embryos
were transferred during the first quarters of 2004 and 2005.
The records are grouped by year and quarter. I used the
following two ways to count the number of records in which
the TrfNo>0 during these quarters.
TrfsD: DCount("TrfNo","Cycle Info","[TrfNo]>0")
Trfs: Sum(IIf([TrfNo]>0,1,0))
In both cases in the Total row of the query I chose Expression. The
DCount function gives the same (incorrect) result for both quarters. Please
tell me why.
With thanks,
Andras
I am comparing the number of cycles in which embryos
were transferred during the first quarters of 2004 and 2005.
The records are grouped by year and quarter. I used the
following two ways to count the number of records in which
the TrfNo>0 during these quarters.
TrfsD: DCount("TrfNo","Cycle Info","[TrfNo]>0")
Trfs: Sum(IIf([TrfNo]>0,1,0))
In both cases in the Total row of the query I chose Expression. The
DCount function gives the same (incorrect) result for both quarters. Please
tell me why.
With thanks,
Andras