Date Wildcard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that counts the number of projects people have started or
finished based on date fields. I was able to count the projects started using:
=Abs(Sum([Auditor] And IsNull([Ph2c])))

But I am unable to count the number of projects finished. I want to say,
basically, Count "Auditor" if Ph2c is not Null.
I have tried:
=Abs(Sum([Auditor] And IsNotNull([Ph2c])))
=Abs(Sum([Auditor] And [Ph2c]="Like #"))
=Abs(Sum([Auditor] And [Ph2c]="#Like *#"))
=Abs(Sum([Auditor] And [Ph2c]="Like *"))
=Abs(Sum([Auditor] And [Ph2c]="#1/1/1900#"))

But none of these things have worked. Any ideas?
 
Try these variations.

=Abs(Sum([Auditor] And IsNull([Ph2c])=False))

=Abs(Sum([Auditor] And [Ph2c] is not null)
 
This worked Great! Thank you very much.

John Spencer said:
Try these variations.

=Abs(Sum([Auditor] And IsNull([Ph2c])=False))

=Abs(Sum([Auditor] And [Ph2c] is not null)
I have a report that counts the number of projects people have started or
finished based on date fields. I was able to count the projects started using:
=Abs(Sum([Auditor] And IsNull([Ph2c])))

But I am unable to count the number of projects finished. I want to say,
basically, Count "Auditor" if Ph2c is not Null.
I have tried:
=Abs(Sum([Auditor] And IsNotNull([Ph2c])))
=Abs(Sum([Auditor] And [Ph2c]="Like #"))
=Abs(Sum([Auditor] And [Ph2c]="#Like *#"))
=Abs(Sum([Auditor] And [Ph2c]="Like *"))
=Abs(Sum([Auditor] And [Ph2c]="#1/1/1900#"))

But none of these things have worked. Any ideas?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting from 2 different tables 2
Adding a second summary field/page?/Merging summary report 1
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Reports for Yes/No Variables - Help! 3
Record Source Error - Can't use a pass-through query or a non-fixed-column query 0
Dup recordeds being counted 1
Date Limit in Crosstab from Union query 2
=Sum(Abs) and Date Range Question 3

Back
Top