Syntax 1

[Moose222]

I am trying to put an equation in the report section where:

In one column [GCFLAG] there are G's and C's.
In another column [SHIPDATE] there are dates of order.
And lastly I have a date of report Date()

I need to count the # of G's in GCFLAG and then compare the order dates to see if they are <= the date of the report.

I need to count the # of G's in GCFLAG and then compare the order dates to see if they are >= the date of the report.

So far here is what I have tried, but it dosen't see to work:

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

The answers that I seem to be getting are either ALL or 0. It dosen't see to be pulling out the G's.

Thanks for any help.
Jim Nelson

 

[CosmoKramer]

Try:

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

 

[CosmoKramer]

Sorry, forgot a quote....

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

 

[Moose222]

Outstanding !!!!!

Thanks.