DCount issues

[lite4d]

I have a report that I am trying to complete based on several queries. I am trying to count the number of records based on certain criteria and using the following DCount.

=DCount("[Calculated time]","IPG1","[Calculated Time] <= 0.04" And [Ship-to party] In ("SN00207PJZ","SN09162XXX","SN09324XXX"))

I want to count the number of IPG1 records that are under .04 and have the Ship-to party of the ones listed. I have tried everything that I can think of to get it to work but can's seem to get it to. I figure it's something easy but I don't see it.

Thanks in advance,

Chris

 

[pbaldy]

Try

=DCount("[Calculated time]","IPG1","[Calculated Time] <= 0.04 And [Ship-to party] In ('SN00207PJZ','SN09162XXX','SN09324XXX')")

 

[namliam]

=DCount("[Calculated time]","IPG1","[Calculated Time] <= 0.04 And [Ship-to party] In ('SN00207PJZ','SN09162XXX','SN09324XXX')")

Try that

pft, Paul ....

 

[lite4d]

Try

=DCount("[Calculated time]","IPG1","[Calculated Time] <= 0.04 And [Ship-to party] In ('SN00207PJZ','SN09162XXX','SN09324XXX')")

I knew it was something silly I was missing. I have been racking my brain all morning trying to get that.

Thanks!

Chris

 

[pbaldy]

Happy to help!