var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: count different
I have a question.
Suppose there is a table:
Dcount("Code","table","Vendor = A") = 2
It is fine.
Dcount("Code","table","Vendor = A") = 3
I want to count the different between the code, it should be 2.
I don't want to create the query to group it and then count the query, because the values of the rest of the fields of the table may be different.
Does any function for count different? Thanks.
Group Vender and Code then count then
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
based on my own environment: vb6 sp5
based on my own environment: 5.6
based on my own environment started 2007
based on my own environment started 2008
MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Either you're using funny math or I'm unclear as to how you're making that calculation...
Originally Posted by
If your BE is SQL Server there is a jolly nice DISTINCT qualifier for COUNT
if it is access then you have to fudge (about what Myle said)
SELECT Vendor, COUNT(DISTINCT Code) As NoOfDistinctCodes
SELECT A.Vendor, COUNT(*) As NoOfDistinctCodes
FROM (SELECT DISTINCT Vendor, Code FROM table) AS A
ur codings are working excelent.