Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ralphyehle
-
Expression to count certain rows
thanks for the help! all I need to do was to replace the Is Null qualifier with "". Field is text so Is Null did not work.- ralphyehle
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Expression to count certain rows
This is a query that groups on a field that names counties, so the count is how many ErrorCases are there in each county. The ValidityReason and the ExpValidity fields are both text fields even though populated by numbers, it is possible they could contain a letter.- ralphyehle
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Expression to count certain rows
I want to create a field named ErrorCases that sums the rows meeting the following conditions: The row has a ValidityReason = 2 and for the same row ExpValidity is either null or 3. I want a count of the rows meeting these condtions. Here is the formula I have constructed that does not work...- ralphyehle
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
