cant seem to get a total count of blank records in from a date field in a query using a statement in a form. the records are null and also have other criteria from the query. 1. Count records that are 2. records null in the date field 3. records that have GFM in another field I am able to get the results using a query but want to use a statement in the form if possible
=Count([SCE]="GFM") And Nz([Forecast Ship Date],#1/1/1990#) And [Forecast Ship Date]<Now()
DOUGLAS BAGGETTOP
@Reply 2 years ago
cant seem to get a total count of blank records in from a date field in a query using a statement in a form. the records are null and also have other criteria from the query.
1. Count records that are
2. records null in the date field
3. records that have GFM in another field
I am able to get the results using a query but want to use a statement in the form if possible
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
