count distinct

[misschanda via AccessMonster.com]

hello
i have a query with many different types of sample numbers and test numbers
i want a count of all test and all different types of samples within those
test
therefore if i were to add up all samples i would yield the same test number
as sample number

is there a count distinct function

thanks

 

[KARL DEWEY]

Post sample data with table and field names.
What should the results look like for that sample data?

 

[misschanda via AccessMonster.com]

thanks for the help karl,
it worked out find.
used Ecount() module found on this site

Post sample data with table and field names.
What should the results look like for that sample data?

hello
i have a query with many different types of sample numbers and test numbers

[quoted text clipped - 6 lines]

thanks