Hi Everyone:*
I am working on Database project using DAO. Now I got a problem in counting all the data from one Field:-/ . Please help Me in this problem.
:confused: And Tell Me how can I get the total of any field by using SQL STATEMENT?
Thanks In Advance
Naveed_Cn
0
Newbie Poster
Recommended Answers
Jump to PostHi,
Use This Query:
For Distinct Count:
Select Distinct Count(myfield) From MytableFor Number Of Rrcords:
Select Distinct Count(*) From MytableFor Sum:
Select Distinct Sum(amt_field) From Mytable
Regards
Veena
All 3 Replies
Reply to this topic
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.