Syntax

[Moose222]

In one table called NHSTAT, I need the total of a column called [GCFLAG] that has 'G's.

In the other table called NASTAT, I need to check the column [SHIPDATE] against the Report Date or Date().

Basically, I need to check the Total of [GCFLAG] from NHSTAT and add the the total of [SHIPDATE] from NASTAT < = Date().

As far as I can tell the equation below checks for G's in [GCFLAG] and [SHIPDATE] <= Date() from the NHSTAT table:

=DCount(&quot;[GCFLAG]&quot;,&quot;NHSTAT&quot;,&quot;[GCFLAG] = 'G' And [SHIPDATE] <= DATE()&quot

Can anyone help me writing the equation to have it check for [SHIPDATE] from the NASTAT table and the total from [GCFLAG] from the NHSTAT table.

Thanks in advance for any help.
Jim