Count with Criteria in Access

Hello!

I am trying to have to system count the number of birthdays that fall within the criteria range that I have set; however, when I run the query, it just shows up blank. If I run it without the criteria, the count feature works. Could someone help me out?

Here is the query that is showing up as blank:

Image

Answer
Answer

Add the Birthdate field to the query grid a second time.

Set the Total option to Where.

Move the criteria from the original Birthdate column to the new one.

---
Best wishes, HansV
https://www.eileenslounge.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 15, 2025 Views 64 Applies to: