Problem with dAvg syntac

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NNlogistics - 31 Jan 2008 15:33 GMT

I want to be able to look at the average of a field when there is a entry in
another field and again when there is no entry in the other field.

So for no entry in "fldSupplierID
=DAvg("[TurnAroundTime]","qryQualityListRepairsShippedByDate","[fldSupplierID]is null") ' which seems to work?

and for an entry in "fldSupplierID". If the above worked the
=DAvg("[TurnAroundTime]","qryQualityListRepairsShippedByDate","[fldSupplierID]not isnull")
Doesnt

Any suggestions

Signature

Thanks for any assistance

Reply to this Message

Klatuu - 31 Jan 2008 18:08 GMT

It should be:
","[fldSupplierID] is not null")

IsNull is a VBA function. For SQL it is Is Not Null

Signature

Dave Hargis, Microsoft Access MVP

> I want to be able to look at the average of a field when there is a entry in
> another field and again when there is no entry in the other field.
[quoted text clipped - 7 lines]
>
> Any suggestions

Reply to this Message