hi! can you please help me. I want to count all "OPEN" in my status column. im using access for my database. thank you!!!!
mishael.pestano 0 Newbie Poster
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
maybe this is what you want? It's written in php, but the sql code is the same in any language.
For example
SELECT COUNT(*) from [tablename] WHERE status = "OPEN"
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.